-
COUNTIFS Formula Based on Status and Due Date
I'm looking to create a formula that will count the number of overdue tasks. This is based on the "assigned to", "status" and "due date". My current formula is =COUNTIFS({[Sheet Name]}, <TODAY(), {[Sheet Name]}, ="[Assigned To]"). However, this is pulling tasks that are due in the past, but are completed.
-
Names not emails as titles
This is pulled from a column of responsible person. Why does it display email and not name. How do I correct?
-
Change color of milestones in Gantt
Hello. I would like for the Gantt to reflect my organization's color scheme better so that I don't have to recreate Gantt charts manually in PowerPoint presentations for sr leadership. Currently, I can change the bars in the Gannt, but I cannot change rollup bars or especially milestone diamonds.
-
How do I list all predecessors (direct and indirect) for a given row?
Does SmartSheet have a way to list out all of the predecessor rows that feed into a given row? For Row 22 in the example below, I would like the formula to return the values 20, 19, 18, 17, & 16. Either that, or I would be looking for a list of all direct and indirect successors to a given row. Either would get me where I…
-
Report for Non-Aggregated Days
Our contracting companies submit invoices monthly, and the invoice dates reflect the actual calendar dates worked. However, in Resource Management (RM) and Advanced Reporting, time data is aggregated by week. When I filter for January 1–January 31, the system returns data based on the week-ending date. As a result,…
-
Enhacement Request : Hide & unhide rows and colums with conditional formatting
Hello, It will be useful and efficient to have below functiobalities in future smartsheet releases: 1. Hide & unhide rows and columns 2. Hide & unhide rows and columns with conditional formating Regards Faizulla
-
Export with ALL comments
I can't seem to find a way to include all comments in an export to Excel. The export only shows the latest comment or set of comments. Pulling a row report doesn't give an option to include comments. And the Conversations view doesn't give a way to export all the comments from that angle, either. Any ideas to gather all…
-
UPDATE - Health and Wellness Solution
Here is what I have built out so far for my Health and Wellness Solution. Please note some information has been redacted, including my Forms Dashboard which is where I go to log most of my entries, it is more for me to see, it's not as pretty as these are. I'm a dork and record many things just for the fun of it. I started…
-
Checkbox Evaluates Differently
I have a checkbox column [H-SD (Added)[ with this formula: =IF([H-Supplier Type]@row = "Individual", IF(COUNTIF({SD-EmailPrimary}, [Email (Primary)]@row ) > 0, 1, 0), IF(COUNTIF({SD-EmailPrimary}, [Organization (Email)]@row ) > 0, 1, 0)) In another column, i want to evaluate if that column is checked or not, so I put this…
-
Ranking when duplicates
I need help with a challenging formula. I have the following situation: Row# Value Score Effort Score Priority Score Rank* 1 50 5 45 4 2 70 10 60 1 3 65 5 60 2 4 60 20 40 5 5 70 25 45 3 If Priority Score = Value score - Effort score then rank by priority score (with greatest priority score = rank 1) if priority score is…