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
Hello I could use some help with this one. I got the formula to work in the "number column"…. but I cant currently get it to work as a column formula. Basically what I am trying to achieve is have it add a number in order if the "footer comp" column is unchecked. and miss is unchecked Right now it is counting but in the…
I'm need to apply a function to average a column (answer is correct (8)) if the other column (The nurse is caring for a a patient who dove into a) is NOT blank. I copied this over from an excel spreadsheet. I would like to keep the average in the top row. Right now it's saying "#unparseable" as the formula is not the same…
This discussion was created from comments split from: How do I combine multiple INDEX Collect formulas in one Formular?.