I'm pretty new to smartsheets and can't quite get the syntax right for what I'm trying to get at. This is what I'm trying to achieve in plain language: IF YEAR([Due Date]@row) = YEAR(TODAY()) AND(WEEK…
Hello all - I'm looking for some formula help. Without getting to deep, I'm looking to develop a formula that can extract the emails from Latest Comment, regardless of their position in the comment, i…
I am new to smart sheet attempting to create a budget tracker and will need to total the spend by month, for now just using actual spend. I tried a formula I saw online and keep receiving unparseable,…
Happy new year Smartsheet crew! I'm returning the quarter of my end date using this formula: =IF(MONTH([End Date]@row) <= 3, "Q4", IF(MONTH([End Date]@row) <= 6, "Q1", IF(MONTH([End Date]@row) <= 9, "…
Hi All, Beginner user here :) I would like to cross reference a member number on a sheet that is generated by a form to a master list on another sheet to see if that member has submitted the form. Thi…
Hello all I am trying to create a formula to imitate the following filter login in another sheet i am trying to pull a single figure via a countifs function from 5 different columns if any one of the …
Formula Gurus - I need a formula that can be applied as a column formula in my column named Actual Duration (Days). IF the row is a PARENT row, the formula should return the sum of its children rows. …
I used the AI formula generator in Smartsheets and I'm still getting an invalid column value error. I can't figure out why because there is data in the column. If the IMP/DISC column displays Implemen…
Hi - I'm trying to write a task health formula with the following criteria and am hoping someone can help. Here's what I'd like it to calculate: BLUE (NOT STARTED): If the start date is in the future …