-
Separate predecessors for start and end dates
How can I set the start date based on a predecessor of row X and set the end date based on a predecessor of row Y?
-
Help on getting the SHIFT from a time
Hi, I m trying to extract the shift where and inspection is conducted. primary time source is CREATED DATE column, than I extracted the time using the formula " =TIME(RIGHT([Inspection Date]@row, 8))" however I can't figure the approach to get to the Shift if I am hoping a return of 1, 2 or 3 from: Shift 1 = 0600 - 1359…
-
Getting “Unparseable” error on nested IF/AND/OR formula with cross-sheet references
Hi everyone, I’m rebuilding an Operational Status formula that references another sheet for quarter-end deadlines. The formula works logically, but Smartsheet keeps returning #UNPARSEABLE. Here’s the current version (I’ve confirmed all range names and column types are correct): =IF( AND( OR([Step 1: CQ LAUNCH Required (Yes…
-
Question for Countif function
Hi There, I'd like to count the cells which year belongs to 2024, seems the formula I wrote cannot capture the correct volume, may I seek your help for it? which part is wrong in my formula? Details as following: My formula: Reference column: Thanks in advance!
-
Sequence numbering based on another Cells info.
I'm looking for a formula to sequence document numbers based on another cells info. I've set up IF functions to code each main column (in blue) which will be hidden in the background & locked to which i then used a JOIN function to get a serial code. (shown in "document Code"). With those in place, On "Document No." Column…
-
Problems automating and matching with formula
Hi, I have a formula that used to create an order number, composed from the following fields: The date date + an auto number, then the "/" character gets removed. Our vendor also uses Smartsheet. I have an automation set up to send the information over to the vendor, but it doesn't transfer right. It consistently transfers…
-
Checking a column for a single cell that meets all conditions
I have a form that has two multi-select columns and I am trying to find a way to create a chart out of the results. The two multi-selects are "Name" and "Food Given" and then a column for the number of days since the food was offered. I want to take those results to another sheet and have it determine if each critter can…
-
Sum cells from a reference sheet based on a range of dates
I need this formula to sum cells in a reference sheet based on dates. The reference sheet has a column with dates, and there could be multiple of the same date. I was able to get this formula to work on the top line in the screenshot, but the next line is adding the 2 week ending sums together. The planned bushels for week…
-
Assistance with IF, AND, OR statements
=IF([Due Date]@row > TODAY(), IF(AND(Status@row = "In Progress", Status@row = "New", Status@row = "Not Started"), "Yes", "No"))) The goal is to flag items for escalation based on the due date and status. If the due date is in the past and the status of the risk or decision is in progress, not started, or new then I need to…
-
Target Start/End Date
Ultimately, I need a good way to track if we are completing tasks on time based on our original estimates because we have users that estimate a task will take 5 days and when it takes 15 they just change the dates, and the project status still looks green, when is reality it is behind. I would like to have target start/end…