-
Harvey balls based on range of values in % completion
I have a formula to use based on % completion of a project. I would like Harvey balls to show the status based on a range of values. It's not often that completion is exactly 25%, 50%, 75%, 100% This is my formula but how do I figure the ranges? =IF([% Complete]31 = 0, "Empty", IF([% Complete]31 < 0.25, "Quarter", IF([%…
-
Sumifs
Does anyone know how many criterion you can have with a SUMIFS? This formula works =SUMIFS([Conversion to $US]$21:[Conversion to $US]$385, [Cost Centre Description]$21:[Cost Centre Description]$385, [Cost Centre Description]6, [Fiscal Year]$21:[Fiscal Year]$385, [Fiscal Year]6) But when I add one more criterion such…
-
iterate same smart sheet set up for a new year
Hello, I am very new to smart sheet. Can anyone advise on how to iterate the same current setup/template for a new fiscal year set up? Many thanks
-
Reverse Engineering a Timeline
Is there an easy way to reverse a timeline that was originally based off of a start date, but should be based on the end date? We plan a lot of meetings where the meeting dates are always moving and we want to adjust the way we have our timelines so we can change the meeting date and Smartsheet can fill in the dates of the…
-
Comments Column
I use smartsheets mainly as an issue tracking tool when dealing with contractors. Many of these individuals are willing to type into boxes and info that is needed but are not usually tech savy enought to realize that to post a comment they need to click on the blank cell/bubble in the Comments column. It would be a great…
-
Do not sent Alerts if the row is marked as complete
We use SS for task / acrion lists for various teams, projects etc. and reports to consolidate everything into a single action list for the individual. We use Alerts to remind people. How could I stop the Alert sending if the item is marked as complete - we use a drop down list for the item status - In Pogress, On Hold,…
-
newbie questions
I would like to create a worksheet which tracks our purchasing and the vendor I source from. and it the same sheet have another tab which have the vendor contact information. When I double click on vendor in the master tab it will help pull up the vendor contact details that is on another tab. Is that possible? Does…
-
Feature Request: timestamp() function
It would be great if there was a way to timestamp the value of a cell. To enter the exact date that an event occurred. Several people have volunteered a modified date column, but something like the following functionality in an if-statement would be really great. =IF(FieldName1 = "blah", timestamp())
-
Schedule Duration Issues
I've been working in a CPM schedule. The original showed a 141 day duration, starting 12/12 and ending 05/04. I'm updating some of the relationships as I had to rearrange the work pattern a bit, now my schedule shows 144 days, starting 12/12 and ending 6/29. Does anyone have an answer as to how I gained only 3 days…
-
Changing Parent to red, yellow, green based on child
Hi, I'm trying to create a status report that will change the parent status to "Red" if one of the children are in "red", or yellow if the child milestone is in Yellow. These are milestones, so there should rarely be a red milestone and a yellow milestone at the same time, unless we're really off track. Can anyone help?…