-
Automatically Setting a Future Date Based on Criteria
Is there a way in Smartsheet to automatically default a date column to 30 days in the future based on certain criteria? For example, if Column A has a value but Column B is left blank, can Column B be set to automatically populate with a date 30 days from today? I tried creating an automation where the trigger is when…
-
How to link Task Start and end Dates to another project template file using a formula
I would like to update one task in another project sheet and have it automatically update on another sheet that showcases the more detail project specifics about that installation. I have thought about using the Index and Match formulas, but that would have to hard code the date and the date would be changing.
-
Formula To Set Urgency Based On Multiple Criteria (Fields)
Hello, I have a sheet that lists requests, and I want to write a formula for the Urgency field (Critical, High, Medium, Low dropdown options). Estimated End Date Actual End Date Users Affected Work Blocked Users+Blocked Urgency Status 06/19/26 06/12/26 15 No Completed 06/11/26 17 Yes ! Critical In progress 06/15/26 5 Yes…
-
Sheet Summary Formula
Hello- I am trying to get a formula to display a certain cell- Hours Available in Week when the Team Member is Jaclyn and the Week Number is 22. I keep trying the formula below: =INDEX(COLLECT([Hours Available in Week]:[Hours Available in Week], [Team Member]:[Team Member], "Jaclyn Light", [Week Number]:[Week Number], 22),…
-
Automation won’t stamp “Last Changed” date when Status is formula + linked cells
Hello! I’m trying to timestamp when the value changes in a Status column I've created, but the Status column is formula-driven and its inputs are linked cells / cross-sheet references from multiple source sheets. In my Master sheet, the Status column is a formula. The fields that drive that formula are not manually edited…
-
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
-
Need to find the whether the task done on time or not with DATE + TIME Functions
3 Teams handle this Deadline, 1 day each. Total Deadline 3 Days. Each day 24 hrs deadline. Ex: Received Date/Time 06/08/26 7 PM to Due Date/ Time 06/11/26 7 PM. ( 7 PM is not fixed irrespective of time, but we need 3 working days as deadline not 7 days - Mon to Fri) 1 Scenario: Team 1 If Received Date/Time has text value…
-
Splitting multiple form answers
I've seen a few workarounds for this, that usually require another party or app. I've also seen "basic" formulas using INDEX, for this, but as someone who is VERY new to Smartsheet, I'm hoping for some additional guidance. I created a form, essentially for class registration. Sometimes people sign up for 1 class, sometimes…
-
Count Blanks from Referenced Sheet
Hi all! I am attempting to count the Blank cells in the 'Assigned to' column of another spreadsheet and have it not include the blank cells at the bottom when the rows are also blank. This is the formula I'm using now, but it is counting those blank cells/rows at the bottom of the reference sheet: =COUNTIFS({Deposit…
-
Formula broken on one sheet but not broken on others?
Hello Smartsheet Community! I have a formula that is acting up on one of our sheets. We use a budget sheet that is standardized across multiple Business Units and one of the sheets is currently throwing an #INVALIDVALUE error with the below formula. =IF([PO or CC]@row = "Purchase Order", SUMIF([Salesforce…