-
"Last 7 days" filter is different than >TODAY (-7)
Hello, I need a sanity check: Following a crazy chase for a discrepancy in my sheet, I found out that if I create a filter "In the last 7 days", it starts counting yesterday as day 1. But if I calculate SUMIF is the option {Date} > TODAY (-7), it counts today as day 1. So, my final SUMIF tally is off compared to adding the…
-
Not sure which formula I need...
I am trying to pull data from the ISIR Pull 2023-2024 sheet and make it populate the information into another range on another sheet. I want the ISIR Pull 2023-2024 sheet to match the Student ID to the Jones Scholarship sheet and pull in the FA23 HRS without having to hand-type it. (Work smarter, not harder, right?) The…
-
Same subtasks for all projects..
Hi all, I'm new here, so sorry if the question's been asked before and I couldn't find the answer, but: I work on multiple projects at once, and they typically have the same group of tasks for each (I work in communications, and for every event (/project) I draft the same suite of products, and they get approved in the…
-
Workaround for countif miscalucating unchecked boxes in column
Looking for any advice, guidance, on calculating unchecked boxes. I would like to use summary data and post to a dashboard for review and status of how many unchecked rows. However, it counts the added/unused rows at the bottom of the sheet showing an incorrect calcuating of unchecked marked boxes. We add rows to the sheet…
-
Formula to count column but exclude information within the column
I have a list of Job Classifications that is very long and I need a Countifs formula that can exclude 1 specific job class so that it can count all the others?
-
Formula to add days to a date
I have a dropdown column for PM Frequency (1 month, 3 month, 6 month etc...) and date columns for last PM and next PM. I want to add the appropriate number of days to last PM to generate a date for next PM based on the PM frequency. What is the best way to write a formula for this?
-
COUNTIF or SUMIF Formula in Report Summaries
Currently the summary count function only supports basic formulas. It would be great to be able to have the ability to use a COUNTIF or SUMIF Formula in report summaries. Specifically to count only the checked boxes. This feature would be nice to roll up metric data quickly and avoid the need to create a separate metric…
-
How to put a date and time together in a column?
Hello, i am fairly new to smartsheet and Formulas, i was using a Created date column in Vlookup but looks like that column is in TEXT and is not being read as a Date and time.(maybe i am wrong). i have managed to use a couple of formulas to bring out the date and time in 2 separate columns, i want to put them together now…
-
RYG Parent Changes with Daughter Scheduled Health Change
Dear Smartsheet Team I am trying to get Parent [Scheduled Health to reflect 'worst color' from daughter lines. The logic: if any one of Line 3 or Line 16 or Line 20 (of the [Scheduled Health] Column is Red then Line 1 is Red If any one of line 3, 16, or 20 is yellow then line 1 is yellow if all line 3, 16, 20 green then…
-
Join ancestors EXCEPT the top level
Hi Smartsheeters, I would like to group my milestone report by workstream, so I added a "join ancestors" column. I also have a "count ancestors" column that can be used. My current report is a nightmare when sharing, as the top ancestor is the project name, and I can't control how massive (and not wrapped) the group header…
