-
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…
-
With App DataTable, How Do I Interact With Formulas?
I will give basic examples to see if what I would like is possible. In all cases lets assume the amount of data is >20000 rows, so I can't just add to another sheet. How can I find the max value in a column called Count? How do I find the max value in a column called Count where column Category is Category B? How do I find…
-
Prepopulate Form for Update Request
We use forms to get information from our colleagues and we would want to send them a form prepopulated by their inputs so they can update the information if there are any changes. This would be very useful if we can automate the process and make the items mandatory