Formulas and Functions
Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.
Discussion List
-
Populate a cell with today's date when status is marked completeIn Formulas and FunctionsHi all, We have several task schedules that people use to track the status of their work. When the task is finished, they change the Status to Complete and the Percent Complete to 100%. We would also like to know the actual date the work…
-
Checkbox formula using =IF(ORIn Formulas and FunctionsHi, I am trying to find a formula to check a box based on another cell in the row having either maintenance OR support (along with other text) but keep getting an #INCORRECT ARGUMENT SET error. The formula works perfectly for one crit…
-
Question on SumIFSIn Formulas and FunctionsWe're hosting a "Bike to the Moon" where our supporters are uploading their daily trips, miles and emails in a worksheet. We want to display a riders' individual trips (showing date and miles traveled) and a total miles field tha…
-
Can selections from a list be added to each row under a job based on job criteria?In Formulas and FunctionsI am not thinking this is a possibility, but thought I'd ask in case I missed something. Can a list of tasks be populated in the rows under a new job row based on criteria in a different row? For instance, I have a column for project typ…
-
Keeping track of datesIn Formulas and FunctionsI want the time a specific cell is edited to be automatically placed in a cell. I don't want to use the column setting because that updates when any cell in the row updates and not just the one I want. Is there a way to do this?
-
Formula within a formulaIn Formulas and FunctionsGood afternoon everyone, I was wondering if it is possible to do an IF formula with a date formula in the same cell? I would like to do the following, but also subtract the number of working days between two dates. IF([email protected] "…
-
Gnatt Sheet CalendarIn Formulas and FunctionsOn the Gnatt Sheet, can you have multiple duration columns to show multiple dates within 1 row? Thank you! Tiffany
-
Simplifying SUMIFs formulasIn Formulas and FunctionsHi In my summary sheet, I am calculating the total of all CEs value for all my Agents using the following formulas: (Image) =SUMIFS([CEs:CEs], [Agents:Agents], "Agent1") + SUMIFS([CEs:CEs], [Agents:Agents], "Agent2") …
-
Help with Count If formula on unique values onlyIn Formulas and FunctionsI am trying to add a count to my sheet summary which gives me the number of contracts which are a certain status within my sheet eg. pending, signed & returned etc but each contract can be listed a number of times within the sheet and …
-
Trying to Input a formula to automatically generate a symbolIn Formulas and FunctionsI have a column where I am tracking percent met and I want that percent to trigger a symbol in the column next to it. The symbols I am using are the 5 circles (Empty, Quarter, Half, Three Quarter, Full). This is the code I tried =IF([Perc…
