-
Re-write a formula to make it Column Formula compatible
I have Concept phase projects that can result in multiple Phase 1 projects being generated from one Concept Review. I want to calculate the time in the Concept Phase for the first project from that Concept (the Approved Gate 0 UID), but mark it N/A for any subsequent references to that UID. I figured out the formula below…
-
Can I use a sheet to create a purchase order form?
I'd like to create a purchase order form that allows users to select items from a drop-down list and display the quantity and total of each item. I have created a sheet, but all of the items in the primary column do not appear as a dropdown.
-
How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
-
Reference links break in formula
I want a formula that can reference updates on another sheet and add the info onto my sheet. The other sheet is a schedule that has job locations and PTO time for each individual on each day of the week. I want to know the dates that each individual on the sheet has an upcoming PTO, and for my sheet to update with 'PTO' on…
-
How can I set up recurring tasks in Smartsheet?
I need tasks that repeat (daily, weekly, monthly, yearly). Each should show a due date and a “Completed” checkbox. When I check it off, I’d like the task to log in an archive sheet with the completed date and then reset on the main sheet with a new due date and cleared checkbox. Has anyone found a simple way to do this?
-
Netdays Formula
I am wanting to calculate Netdays but only if there is data in 'Corrective Action 1' I am currently using this formula: =IF(ISBLANK([Date Action 1 Complete]@row ), NETDAYS([Date of Event]@row , TODAY()), NETDAYS([Date of Event]@row , [Date Action 1 Complete]@row )) How do I adjust it to only pull a date when Corrective…
-
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
-
Missing column in Report if I use a formula
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?
-
Split Multiple Selections In Single Form Into Individual Columns
If I have an option on a form for a multi-date selection field is there a formula that could help break out each date selected into its own column. So if it was a sign up form and they wanted to select 3 dates to work then each date they are working could end in its own column. Then I could set a reminder automation based…
-
Formula to pull in contents in a cell that survives deleting rows
What is the best formula to pull in the contents in a cell in the same column even if the original row is deleted? Background: I'm building a Profile Data sheet for a new blueprint. This blueprint has several optional project plans. Each plan will be on the profile data, capturing things like Start/End dates, schedule…