-
Request for Update Report (or something like it)
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…
-
Help With If Count If to Identify Unique Values in a Column
I'm trying to make a helper column to identify if a new/unique project code has been entered in a column so that I know when a new project has been created. I've been trying to set up this formula and plan to then set up an automation to be notified when "New Project Code" has been entered into a cell. It seems to be ok on…
-
Why does the parent task my % column show as a decimal value instead of a percentage?
Why does the parent task my % column show as a decimal value instead of a percentage? I checked the column and project settings, and they are identical to another smartsheet in which the values show up as a percentage.
-
Auto Populate 10 rows with todays date each day
Is there a way to automatically add today's date to 15 new rows each day without deleting previous dates? This would let us track pull the 15 daily task items that need to be completed each day.
-
Create Formula at Grouping level
Hi, I have a source (and detailed) Smartsheet page with a lot of "detailed" transactions/rows. I created a report where I'd like to group the data and get some subtotals at the same time. If you check the picture (my new report), I'd like to group by "Task Name" , sum the "Hours", return the max of the "Estimated duration"…
-
Find missing/deleted scenarions
I have 2 sets of scenarios. The first set is a full original set. The second set has been modified, some scenarios might have been deleted. How do I determine which scenarios were deleted between the full set and the modified set. Each scenario does have a unique scenario ID. If possible, I would like to determine the…
-
Average Formula
I am looking to get a formula on my metric sheet cross referenced from the survey results sheet. I am looking to get it as a number average but also separately a percentage as well. One thing to keep in Mind is that each column is a question where they would answer a 1-5 option. On the metric sheet it is separated into…
-
Sum last n rows
Does anyone know how to write a formula that will sum up the last four rows only? Example- The GPO Volume dollar amount gets populated each quarter. I would like a formula that would remove row 11 and add in row 15 once the value is in there so I can only show the last 4 quarters total volume. Thanks in advance!
-
SUMIF cell values land within a given week
Hey, I've gotten some fair formula experience over the last year (mostly through googling and this searching this forum) but hit a brick wall with my latest ambition… I have a smartsheet in Gantt mode tracking events and sizes relating to the event. I'd like to be able to use a date picker in the summary tab to pick a…
-
IF/OR Formula issue
Hi, I'm trying to pull data from another sheet if the date meets the criteria in one of two columns of 12/20/2025. Should I use an if/or or nested ifs? Here is what I have so far but get the #INCORRECT ARGUMENT SET error. Here's what I have so far. Any idea what I'm doing wrong? =IF(OR(INDEX({cutdate}, MATCH([Job ID]@row ,…