If Then Formulas
Comments
-
I just started experiencing the block issue yesterday.
Its quite annoying. -
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Haha. No, this is my first time. I thought this was a recent update to the community but perhaps I am mistaken!
-
Everything is relative! It's been annoying me for the last month.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
The CountIF formula worked, thank you all!
-
Glad we could get this sorted out for you. Teamwork makes the dream work.
-
Excellent!
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
For the countIF formula, since it uses a range, if new line were continuing to be added to the sheet, would I have to keep updating the range in the formula, or is there a way for this to automatically update?
-
Happy to help!
[Column Name]:[Column Name] is referencing an entire column. It will include new rows. The only time you would need to update a range to account for new rows is if you specified row numbers such as [Column Name]1:[Column Name]5.
-
Amazing, thank you!
