-
How can I add days to a date field within a logic formula to output a true/false value for a chkbox?
My objective is to create a new column where a box is checked once the row meets desired criteria. The checkbox will help me filter-out rows that will be synced via a Salesforce Connector workflow. The logic criteria is as follows: "Overall Status" = Blue (complete)….and…. "Working Launch" Date + 7 Days </= Today's date…
-
how to keep historical sheets from triggering the formulas
Hi, We have some Smartsheet that we need to keep for historical reasons. And we backed up the sheets. How can we prevent the formulas from triggering to avoid recalculations in the historical archived Smartsheet's?
-
Form Submission - Date Help - URL string
Hello all, another form submission question. Have 2 sheets, and those sheets each have a form associated with them. On Sheet 1 Form 1 someone will place all campaign information in this form, one of them being a campaign start date. After form 1 is submitted, a link to form 2 is presented in sheet 1 that takes campaign…
-
COUNTIFS + AND Formula does not Equal the Filter Count
Good afternoon. I am having issues with the below formula equaling the filter within the sheet that we are pulling form. Please see the below and point me in the right direction to help fix this. Formula: Filter: BC/PO/BL | is one of | PO, BL, SSA, Lease, License, Other Non-Board Items Status | has none of | Awaiting CRF,…
-
Sequential Numbering Autopopulate Row
Hi all! I am trying to create a formula where every time I add a row, it aligns with the next number in the series. If it reaches a level 1 row however, the series goes to the next whole number. I wrote out manually what the numbers should be but I would like a formula to apply this automatically when i add a new row. Im…
-
Populate Column With Unique Values From Another Sheet
Hi all! I have a sheet, where tasks are entered and assigned to employees. Every task belongs to a certain company, which is specified row by row (every row is another task), this describes the first sheet we'll call "Requests". I want to create another sheet to summarize the data of every task for every company, this…
-
Concatenating values from two columns with 20 spaces between them
Hi guys, I have a task to concatenate two strings from two different columns with formula. The values are for example SEA129 and 01. What I want to achieve is a string which will look like this "SEA129 (20 blank spaces) 01" Has anybody encountered similar issue?
-
How to calculate time in smartsheet
Hi, How to calculate difference in time in smartsheet for example Start Time = 12:23:20 and End Time = 20:23:20 I want the difference between this two time in third column = 8:00:00
-
Calculating Age Monthly
I have a smartsheet with many events that often span several months. I want to calculate the average age of relevant events for each month. For example, for the month of March, I want it to calculate the average age of events that are still open in March in addition to the age of all events that were closed within the…
-
Average that meets Criteria 1 or Criteria 2
I have a smartsheet with many events that often span several months. I want to calculate the average age of relevant events for each month. For example, for the month of March, I want it to calculate the average age of events that are still open in March in addition to the age of all events that were closed within the…