-
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 ,…
-
Dashboard % are not matching
Hi! I have a Dashboard feeding off pretty simple raw data. It's mainly detailing this is how many accounts we think we'll get, this is how many we've gotten and then provides a %. I wanted to add a chart just to pretty it up a bit but now the % done is reporting differently and I have no clue why. Here is the raw data: The…
-
Sheet Summary Formula capturing dates before current expiry date column
Hi all, I thought I had this one down but I keep getting an error message. This is a sheet summary formula. Any ideas what I am doing wrong? =COUNTIF([CURRENT EXPIRY]:[CURRENT EXPIRY], >TODAY) Thank you!
-
Pivot Table using Sheet Summary Report #2
Can I use a summary report as a source for pivot table? I need to include different sheet names as columns and add the products for each one of them. I had a pivot using a summary report and it was working as of yesterday but now is not and I cannot recreate it!!! HELP!
-
Conditional Formatting Query
All the above rules are working except the 4th one in the list which asks for the cell to turn red if Group status is not started and end date is in next 14 days. I have used the Smartsheet AI tool but no luck, I have saved and refreshed. I am using a helper column for my 5th rule in the list which asks the cell to turn…
-
Set Task Duration from Formula
I have a project with many repeated subtasks, and sub-sub tasks. To generalize: Task A has Subtasks 1, 2, 3 Each subtask 1, 2, 3 has sub-sub-tasks a, b, c I would like to describe the duration for Subtask 1 with a, b, c in a general set at the bottom of the sheet. Can I link the duration of Subtask 1, 2, and 3 to the…
-
Planned vs actual progress (Summary level)
Hi everyone, I am trying to calculate the % Planed based on the start and finished dates but when I try to set the Complete (actual) progress just to verify that all of my plan y on date, I see that the summary tasks are not calculated correctly. I am using the following formula =ROUND(IF(TODAY() < [Baseline Start]@row ,…
-
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…
-
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…
-
How do I get a column that shows the automated % complete for each activity?
I am struggling to get any formulas to work, I need a column that shows the percentage complete from the start date to the finish date - shouldn't be that hard but this is causing me so much grief. Every formula I find doesn't seem to work and I am not savvy enough to know how to update the formula so that it can work.…