-
Formula to add 1 day to date
I'm having trouble with a formula to add one day to a date based on a condition. I'm sure it is something terribly simple that I'm just missing right now. My formula worked previously when I had AND in the formula with two conditions, but when I only have one condition it adds a 1 to the end of the date rather than adding…
-
COUNTIF Formula for Checkbox Column Not Working in Sheet Summary
I'm trying to create a formula in the Sheet Summary that shows the number of checked items in a Checkbox column named Pending, out of the total number of rows that have either a checked or unchecked box (i.e., excluding blanks). =COUNTIF([Pending]:[Pending], 1) + "/" + (COUNTIF([Pending]:[Pending], 1) +…
-
Multiple IF Statements Using "ISDATE"
I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is: =IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")) I'd like to add an additional criterion that…
-
VALUE RETURNING AS BLANK
I have a data sheet with several items listed and their referenced codes. On another sheet I have a form whereby my engineers can select from a dropdown list the item and whereby, based on their selection, the code should publish in an adjacent cell. The formula I use works for the first item on the dropdown list but the…
-
Limit to Multiple Formulas-All IF statements.
Can you help me write a formula that has 10 different conditions and references multiple columns on the same smartsheet? I've utized the AI tool to assist me but when I get to the 7th formula, it cannot compute.
-
Formula to Turn Number into Date
Hi Smartsheeters! We currently have another system feeding dates into Smartsheet in a number form. For instace, this number (1695686400000) is sent to Smartsheet represents 9/26/2023. How can we convert that number into a date value in Smartsheet? Thank you for your help!
-
Assistance with Formula for 30-Minute Meeting Reminder
Hi all, I need assistance with a formula where I want the box to check 30 minutes prior to the meeting, but I’m hitting a roadblock. The "Start Date" is a Text Column. Below is the formula I’ve tried: Start Date Helper Formula: =IF(ABS(NOW() - (DATE( VALUE(LEFT([Start Date]@row, 4)), VALUE(MID([Start Date]@row, 6, 2)),…
-
Assistance with Conditional Progress Formula Referencing Only One Column
I’m trying to create a formula that dynamically calculates progress based on the value in a Status column. In some cases, I want the formula to preserve the existing progress value when the status changes to “Pending” — essentially freezing the value that was previously calculated. However, since I only have one column…
-
Using Smartsheet to create Time Off Request Calendar, Dynamic View, Form, Report, in Dashboard
Hi all, Through some trial and error I created a Time Off Request system for my team (80 people) I started with grid rows: Employee Email (text), Supervisor Email (text), Division (drop down), Time Type (drop down: Vacation/Personal/Admin/Comp OR Sick/Bereavment/Jury Duty), Start Date (date), End Date (date), Partial Day…
-
Formula for Status Bar
Hello - Please help me build a formula with the below info: Status Bar Column - I want to capture the progress of when a document is being signed with Empty, Quarter, Half, Full values. Columns: Date Received - when a date entered the status bar would change to quarter Date Initialed - when a date is entered the status bar…