department
Discussion List
-
Help with formulas to drive Harvey Ball StatusIn Formulas and FunctionsHello! I am trying to automate the Harvey Ball (R, A, G, Gray) status indicator on my project plan sheet. I am very new to formulas and am not sure what I am doing wrong. Below is a screenshot of the implicated Columns: The values in St…Answered - Pending Review 646 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
CountIF with Criteria including date rangeIn Formulas and FunctionsHello, I'm currently trying to create a countifs formula to count the number of "issue type"(column) "story" where it meets certain criteria including falling within the next 30 days. My base formula works here: =COUNT…
-
Managing Testing with Automation Waterfall Notification and Showing Status with RYGB BallsIn Formulas and FunctionsI have spent some time looking for solutions to my specific need but have been unsuccessful to find anything that fits right, although there were lots of good suggestions that I tried (and couldn't make it work). We are migrating servers …Answered - Pending Review 41 views 1 comment 0 points Most recent by Joanna Waligora Formulas and Functions
-
Advanced formula/function question.....In Formulas and FunctionsI am trying to write a complicated "if" function to search text and provide me with a result if any of the words in quotes are found in the text string. The formula works in excel but I cannot figure out how to replicate it in S…Answered - Pending Review 28 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
RYG and Gray!In Formulas and FunctionsHey, I cant figure out how to add to this formula. I have this formula that someone shared from a seminar: =IF(AND([End Date]@row + 1 < TODAY(), [% Complete]5 <> 1), "Red", IF(AND([End Date]@row -2 < TODAY(), [% Comp…
-
Calendar App - Filters...why did you change the functionality...now...during a Pandemic?!?!?In Apps, Integrations, and Add OnsSmartsheet, Before I lose my mind, here... please tell me that there is (at the very least) a way for individual users to create filters without being shared to the underlying sheet. Up until this change, our users were able to access the …
-
What's an effective way I can plan my resource's hours for the next recurring 12 weeks?In Using SmartsheetRight now, my management asks PM's to predict how many hours their resources will be spending on a given task (tasks = rows) per week (1 week period = 1 column)? What's a possible more efficient way to do this? At the moment, we have to ma…
-
How are you using Smartsheet to help you homeschool during COVID-19 closures?In Staying on the Same SheetWe've been celebrating the social distancing brought on by mandatory office closures and work from home has been great! Meaningless meetings have been cancelled. Chatty Kathy hasn't been stopping by our desks with distractions four times p…
-
Reporting on who and how many times an individual has attended eventsIn Formulas and FunctionsGreeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows: We manage multiple events in Smartsheet. We use forms for sign ups so all…Answered - Pending Review 256 views 20 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Building tasks in Smartsheet: How to sort by dates instead of parent groupsIn Using SmartsheetI'm in the throes of building my first sheet and have finished setting up the dependencies and key tasks I need for my project. Tasks are set up by parent/child groups, based on task type. Now I want to build out the rest of the year usin…