-
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ā¦
-
Is anyone experiencing issues with Completion % not accurately rolling up to the parent row?
We use a change cell value automation to update the standard % Complete column to 100% when a task status changes to Completed. This used to work perfectly, however, recently we noticed that the % Complete for the parent row in our project plan (e.g., Planning, Execution, Closing) is not recognizing the cell update. Ourā¦
-
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ā¦
-
How to record date without time
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time intoā¦
-
count if value is between a date range (reference between 2 sheets)
Hi team i have 2 sheets for material inventory. the first is to record witch equipment is ship out for repair and the other is the total of equipment available. the first is set as follow: equipment type, date out, date return, quantity (negative number) the other one is as follow: each row is for a single date with theā¦
-
Auto Populate "Date Completed" when Status changes to "Complete"
Hello, I am trying to auto populate the "Date Completed" field when the "Status" column changes to "Complete". I tried =IF(Status@row = "Complete", TODAY(), "") However, every time the SmartSheet opens, the date changes to "Today's Date". How can I lock the date in that column once the status changes to complete?