Hi Everyone,
I have shown yes/no type in a form viewโฆ now i need a formula to write a text in that column automatically .
If i give yes : Text 1 - should appear in the sheet
If i give no : Text 2 - should appear in the sheet
Pls help me with the formula.
If you dont need it to be โwrittenโ in the sheet, virtual columns can be the way to go. Add a virtual column, with :
ifs([Col]="TRUE", "Text A",
[Col]="FALSE", "Text B"
)
If you need it to be written in the sheet, you need a data change workflow. Based on your question, I dont think you have got there yet, so either go with the virtual col approach, or if you have to take the second path, first familiarize yourself with actions. How can you use an action to change a โyesโ to โnoโ.
Thank You Pratyayโฆ
Is there is anyway to rename that Yes and No selections
UX > Localize
Thanks Levent,
but this will affect in allover places?? i need this for only one form viewโฆ
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |