-
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?
-
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…
-
Trying to use Time Function to calculate how many days,hours,minutes
I am using this found in the functions list: But Error says #INVALID DATA TYPE. Is that because the columns i am referencing are cross reference formulas and not text/number types? SEE BELOW FORMULA AND SHEET: =DATEONLY([Pending Tech Response Date/Time Stamp]@row) - DATEONLY([Completed Date/Time Stamp]@row) + " day(s), " +…
-
Average with multiple criteria
I am trying to get the average of a column named "Average working Days" while the "STATUS" = "On Hold", "In Progress" and "Not Started" and when I tried it, it gives me #Divide by zero. =AVG(COLLECT({Request Tracker with Form Range - Average}, {Request Tracker Range 3}, Category@row, {Request Tracker Range 2 - Status},…
-
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?