Sign in to join the conversation:
Hi,
is it possible to have formulas added automaticaly to in every row in the column? e.g If someone adds new row or delete it by accident.
Yes, it is. Look here: https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
When I use a formula to return a symbol for example =IF([INC/DEC]@row = "INCREASE", "RED", "GREEN") It just returns the word RED I have the column set to symbol but still can't get it to work…
