-
Timeline
I took the action plan attached my coworker gave me and worked on building a timeline chart. After a lot of research and testing, I learned that Smartsheet doesn’t currently support this kind of detailed Gantt-style visualization with actual dates on the X-axis, mainly due to limitations like too much data and lack of…
-
Determine the "priority" based on alphanumeric values in other columns
I am collecting priorities from various teams, via a dropdown with L, M, H values. How can I determine a "global" priority for each item, which would be the "highest" value selected between the teams? For example, if 2 teams have M and 1 has H then the global would be H. I could create helper columns that assign a value…
-
Create a sheet summary, which counts RAID items and their statuses from another sheet
Hi there, I have a RAID log called "Work Allocation RAID Log" and I would like to create a Summary Sheet so I can see all the types and counts based on status - please see below Type (primary): Action Decision Dependency Issue Risk - with their statuses (columns): Not started In progress On hold Completed Cancelled This is…
-
Form Issue with reloading/submitting after submission?
I have a form that submits to a grid that has been giving me sporadic results for the staff who use it to submit data. They can submit a form and sometimes the form will grey out on the browser or it will submit, but to me doesn't look like it actually reloads and leaves the user at the bottom of the form. The grid only…
-
Using HAS/CONTAINS functions with multiple choices
Hi there! This is my first time posting a question so sorry if I end up doing this wrong!! We run events across the UK and I have a sheet set up for each event site capturing data about the events, from day/date to type of event and breakdown of the number of people who attended. We've now started capturing any 'additional…
-
IF Statements with Dates
Hi all, I am clearly missing something… I have a sheet with columns for the Start and Date Ends and then another column to track the Status (In Progress, Enrolled/Upcoming, Completed). The formula is currently: =IF([Start Date]@row > TODAY(), "Enrolled", IF([Start Date]@row < TODAY(), "In Progress", IF([End Date]@row <…
-
SUMIFS cross-reference date ranges
This is my formula. It's "working" in the sense that it doesn't return an error but it returns a 0 value for each instance when I know some of the values should be non-zero. Any advice is appreciated. =SUMIFS({Consortium HC}, {Consortium Start Date Range}, >=[Week Start]@row , {Consortium End Date Range}, <=[Week End]@row)
-
COUNTIF formula for number of boxes checked is not working
I have a very simple need to generate a count of how many boxes are "marked for disposal" via counting how many cells boxes are checked in a certain column, I have attached a screenshot. The formula is not working, it has given me a count of 0 when placed in text only cell and it does not give me anything when it is in the…
-
Need help with IF AND statement using symbols
I need help with using symbols with formulas. The column property is set to symbols. My current working formula is: =IF(TODAY() > [Remedy Deadline]@row, "Red", IF([Finding Status]@row = "Finding is Closed", "Green", "Yellow")) However, my first IF condition needs to satisfy two conditions: (1) (TODAY() > [Remedy…
-
Sum Calculation including a date range
I need to figure out a formula that looks at column ranges 23-Jan to 27-Jan and sums the totals highlighted in blue, if the date range is within a rolling 12 years from the current date. This is the Excel formula that was used (which was more columns): =sumif($DF$4:$GZ$4,">"&Today()-365,DF7:GZ7) I can't figure it out in…