-
Check Box
Is there a formula or function that will check/uncheck all boxes in a column if one box is checked/unchecked. For example if top box is checked, it will check all the boxes in that column?
-
Sum is giving the wrong answer when adding values generated by "countifs" formula
I used Countifs to generate 4 numbers. I've validated these are correct with the data. I want to Sum these 4 numbers to get a total but it gives me the wrong answer. It should be 407. Why doesn't smartsheet give me the answer of 407? My formula in the Sum Total cell is =SUM([Total # Facilities]9:[Total # Facilities]12)…
-
SUM cells with formulas not working
Hello, I have a sheet with a column of cells with formulas in them. These formulas produce numbers. Then I have a second sheet, where I have a formula in a cell that references the first sheet's column with numbers. This formula in the second sheet is asking to SUM some of the numbers in the first sheet's column and divide…
-
Copy Row Automation causing duplicates
I am using an automation that copies rows which contain the word "submittal" into a sheet where we are tracking submittal dates for all our projects. I cannot use a report because we need to be able to publish to a calendar. Therefore, the end result must be a sheet. As most of you probably know, these dates can change…
-
Countifs for items completed YTD by quarter?
Hi everyone, first time poster here. I need a formula that will count Buy closings YTD by quarter. The best guess I have after reading other posts is: =COUNTIFS([Buy close date]:[Buy close date], > DATE(2021,01,01), [Buy close date]:[Buy close date] < TODAY, [Closing Q]:[Closing Q], Q1) It's not working but I can't quite…
-
Nested COUNTIF with AND
I am trying to use a nested COUNTIF formula with AND function. Column X - check if value is "1" Column Y - check if value is "2" Column Z - check if value is "3" I only want to see the count where all three statements are true. Help!
-
Trying to calculate an "on this day" capacity
Hi There, I have a master sheet of multiple projects. I am trying to work out how an allocated resource can show if it is over capacity in a column - similar to the resource view but so it shows in the sheet itself. So If I have Task Start Date End Date Duration Assigned to Allocation % Hours per day I want to look up the…
-
Formulas not copying to next rows
We have had some issues where the formula is not calculating on a new row when a new form is submitted. The only thing I can see in the activity history is that the new form row came in at 10:24:42 and the row above the new one was being worked by a staff member at 10:24:45. Has anyone seen where formulas stop working if…
-
Error when adding index linked formula
Am getting attached error even though all data is pulling into the sheet correctly, I have info pulling in from 2 x separate sheets. Can anyone confirm if this is impacting data or just an error I can ignore? Thanks
-
#Invalid Operation when determining whether date is in the past
I am working on answering someone else's question, and have come across an issue. I am perplexed! Can you please help me? The formula is to determine whether the planned end date is in the past. If it is, it's to show "Overdue"; if it's not, it's to show "Current." (There will be much more to this formula later, but I'm…