-
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ā¦
-
Performing an Audit - Best Practice
Hi - we are performing an audit and we need to take the data, and have the consumer validate that its accurate, and if not, identify the change required. What's the best way to tackle that? I was thinking a form but there could be lines and lines of data to validate; is it as simple as having them review the sheet forā¦
-
Need a formula that returns a date while factoring in dependencies
Iām looking to add a couple of columns into my project plan sheets. SmartSheet already has a [Start] & a [Finish] column built into its project template, but Iām looking to differentiate between [Plan Start] & [Actual Start] and [Plan Finish] & [Actual Finish]. I renamed [Start] & [Finish] to [Plan Start] & [Plan Finish].ā¦