-
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
-
Numbers Only Formula
Hello, I am trying to have the column "Order/Job #" automatically populate the 6 digit number of the parent row in the column "Customer or Task Name". So basically in the screenshot below, in the WHITE row, column "Order/Job #", it would say 661181. Basically, there will be multiple children rows under each parent, and I…
-
Use SUMIFS referencing start and end dates from another sheet
Hello, I have three sheets. The first one has four attributes (Let's call it Main): [ID, Observation Date, Group, Count] The second one has three (Let's call it Week): [Week ID, From Date, To Date] The third has all the Groups listed and the corresponding weeks where the counts will be displayed based on met criteria…
-
Partial Vlookup
Hi, I need to lookup partial value and map the tagging. There are 2 sheets, main data sheet which is connected with lookup sheet to fetch the Tag. Wherever complete match is found, tag is fetched but i also want to fetch tag in case of partial match i.e. Row3="Yellow" (as DE19-1121 in lookup sheet says Yellow which is also…