-
Does the automation to change cell only work for a checkbox and not for a flag? Very Odd
I am trying to make an automation where if the due date is in the past to automatically flag the cell under the flagged column. However, it will only work if that option is a checkbox and not a flag. I am confused why that would be the case. Is this a problem for others too?
-
Conditional Formatting Referencing a Cell
Hi, I feel that this is something there isn't functionality for, but I wanted to check and see if I may just be missing something. Right now, I have a list of a numbers in a column and then have it calculating the average, upper limit (the average + standard deviation), and lower limit (the average - standard deviation).…
-
Attaching a Message Sent to Vendor Acknowledging Contract
I've set up a Smartsheet that sends an approval request to a vendor to accept the terms of employment (outlined in a PDF generated with information from the sheet). They are not required to sign the document, just click Accept or Reject. While the contract (PDF) is attached to the row, and while I would have a date in the…
-
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…
-
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
-
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?
-
Prevent due dates from falling within the same calendar week?
Hi. I am working on a (roughly) annual document review system, in partnership with another team in my organization. They have requested that they receive one document to review per week. But there are more documents to review than there are weeks in the year. So I need to figure out a method for ensuring that I don't send…
-
Tasks extending from one calendar year into the next
When trying to determine the number of workdays in a month, the following equation stops working when you cross from December of one year into January of the next. Any ideas as to what I'm missing/doing wrong? Thanks in advance! The equation below is for January, I have equations for all the other months of the year but…
-
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…