This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Initial value of blank

Posted on 04-03-2019 03:18 AM
Chris_Jeal
Silver 3
Silver 3
Reply posted on --/--/---- --:-- AM

Hi,
I wonder if you can set a column to reset to it’s initial value of blank, so basically when another column’s value matches the formula then the cell is reset to be empty.?

Thanks in advance,
Chris

Solved Solved
0 15 2,797
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
In response to LeventK
Reply posted on --/--/---- --:-- AM

@LeventK’s IFS() is equivalent to:

IF(
[ColumnA]="SomeValue","Show This",
""
)

or:

IFS(
[ColumnA]="SomeValue","Show This"
)

View solution in original post

Jump to Solution
0 Likes
15 REPLIES 15
Top Labels in this Space