-
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…
-
Weighted Check box's
Just looking to see if there a is a better way to do this. i know i can Write a LONG IF statement to do this. i would like if Step 1 is Check Step Percent would %20 If Step 1 and Step 2 is Checked it would = 75 % if Step 1,2,3 are Checked it would = 95% if step 1,2,3,4 are Checked it would = 100% just looking to see if…
-
SUMIFS - Sum, Restart, Sum Again
Hello Smartsheet Community! I am trying to create a use a SUMIFS formula to add values in a column that are less than 20 within a 7 day range. Once they cross the threshold of 20, the formula should put a checkbox in the row that breached the threshold. Next I want to repeat the process in successive rows, but ignore any…