-
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…
-
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…
-
Checking for duplicates between two different sheets
We are setting up a raffle where we will send out a form for someone to completed to enter the raffle. Once submitted we will take the (Full Name) column and randomly select a winner. We do have a few things on this sheet, we check to make sure there are no duplicates on the sheet, and once a winner is selected and checked…
-
Formula to subtract one month from a date
Hello. I need to subtract one month from a date. I have tried =Date-30, and then minus 60, etc. By month minus 5, I was quite a bit off from the first of the month. If the Date being evaluated is say 4/1/20, I'd like the first calculation to produce 3/1/20, and the next row to produce 2/1/20, and so on. I did find a…
-
Multi selection form into single rows
Hi all, I have a form that allows multiple selections. Once the form is submitted I need the each selection to be added as a new row. I have several issues: -Selection list extensive (50+) therefore cannot be written as separated columns as suggested earlier. -Users will have a hard time to submit a form for each item and…