Formulas
Discussion List
- I have a long list of subcompetencies, that are mapped to course objectives across courses. What I would like like a formula that displays subcompetencies where objectives are equal to "NA", but if th…
- Hi In need of some help. I would like for the formula to sum and then divide a total if two conditions are met condition 1: must be a yes using the green dot with a check mark symbol Condition 2: must…
- Hello Smart Heads! Happy New Year! I am facing an issue with big data sets, missing a single unique ID. The only option of creating an unique ID is by joining content from 3 various cells, see: id is …
- I have a sheet with a hundred some formulas and I will probaby have 200+ at the end of it. Will I have any issues with that?
- Good afternoon, I have searched the smartsheets community far and wide for this answer to no avail. Would anyone be able to assist me in creating formulas for two different scenarios: 1.) I need dates…
- Hi all, I've been deliberating on this one for a while now and not getting anywhere. I have 20 columns which are single select dropdown (with the possibility to free type also). As an example, one of …
- I am having issues finding the most recent update to my list of fleets. I have read about the Max(Collect()) function and don't quite get the result back that is needed. I get incorrect column value, …
- Hello! I am trying to count all of the values in a column that contain the letters "CC:". However, every time I complete my formula it returns with 0 as a result. How can I have it recognize this valu…
- Hello, This seems like a very rudimentary ask but I am stumped. Hope someone can help. Can anyone please suggest a column formula that can bring values over from a sheet based on a conditional lookup …
- I have an IF equation that is working fine for me, however, I would like for anything that is past due to be "Red" in the task health bar. Right now, because I have "Grey" as the first clause even if …