-
How to capture Actual Finish Time for a Cutover Task
I have created a cutover Plan in Smartsheet and all tasks in the plan has these columns : Task, Duration, start Date and Start time, End Date and End time, Actual Start and Actual Time, Actual Finish Date and Actual Finish time. I am able to calculate start and end dates based on duration but I’m only able to capture…
-
Organize the returned value JOIN + COLLECT (?)
Hi guys, could you help me with a case? I don't know if it's possible, but is there any possibility of organizing the values returned to the cell in such a way that, starting with a symbol, the rest is organized right below, as in the next paragraph of the cell ? I'm saying this because with the combination of JOIN +…
-
Formulas Not Automatically Updating
Hi, I have a sheet with formulas in multiple columns. Non-licensed staff are able to add rows of data via a form, and also make updates to existing rows of data via a dynamic view. They view the data via a report. I have this same set up running for 33 separate locations, however one location has been indicating for the…
-
Add Dates into Summary Rollup Values as Text
Hi! I have a sheet with a bunch of summary data at the top (which will be used in reports and Control Center). Two of the summary fields I want to capture are project Start Date and project End Date which are based on the start and end dates from the plan. However, my summary fields are text fields instead of date fields…
-
How to get the difference in dates, but not if the box is checked?
Hello, I am trying to get the number of days between two dates but I dont want to include if the column with the checkbox is checked. How do I do this?
-
Countif with multiple criteria
I am trying to create a countif formula with multiple criteria with one being the approval status and the other being scheduled (which is a date and I want to count it as "1"). I'm trying =countifs(range1, "Approved") +countif(range 2, ???) The question marks if where I am having issues. The column is formatting as a date…
-
How to combine multiple values in a cell based on unique identifier
Hello, I've been reading through many different Smartsheet forum threads on how to do various formulas using Index / Collect / Join / Match functions, however, I have been unable to adapt any of the formulas I'm finding to do what I need to do. Everything either shows up blank or gives me error messages. Goal If there are…
-
Change <60 Days to search by month
So I have this formula which searches the past 60 days. =COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range Issue1}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 2}, ="Pictures", {18b Issues…
-
Give category based on number of digits
I'm hoping to find the best way to write a formula based on the number of digits. I have column called "Area" which contains number of 1, 2, or 3 digits. I need to write a formula in another column to give a designation to the area, either "R" for all 1 and 2 digit numbers and a "C" for all 3 digit numbers. Any help from…
-
Hello - looking for help creating my sign in and out form.
I am fairly new (yet familiar with the possibilities available) in Smartsheet. I am in the process of creating a tracking form for my job to see anytime a device is in use and which employee is in possession of a shared device and what location they are working at that moment. I am collecting the employee's name and ID…