-
Smartsheet Function - TODAY()
I use this function, TODAY(), to calculate days to an event or past said event. I've noticed that you have to open the sheet to update or probably more accurately get the TODAY function to be active and calculate. I use this day counts in a Dashboard and to be accurate, as mentioned, I need to open that particular…
-
Need help creating a formula
I do a project status report for my team. We currently have status options like: "Not Started" , "Active", "Active + Concerns" and "Complete. I recently made another status option: "Cancelled - Covid19". I make a dashboard for my supervisor that highlight the number of projects that aren't complete due in the next 7 days.…
-
RYGB BAlls with B = empty cell
I have a basic formula I can't get to return a B ball when there is an empty cell. =IF(Count@row = 0, "Green", IF(Count@row > 0, "Red", IF(Count@row = "", "Blue")))
-
Time Formats - Number formats - Rethinking the UX and function
Having an entire dialog for text and number formats would make much more sense to me.. combine the currency, percentage, thousands and decimal places into it's own dialog box. We really NEED a way to save and modify the formatting of common things. So as to have them available and globally modifiable across workspaces. Use…
-
Calculate work days in formula, excluding weekends
I have three columns, Projected Hours to complete a task, Start Date and Finish Date. I have a Vlookup that populates the projected hours cell based on a product group identifier. Someone then enters a start date and i have a formula in the finish date cell that calculates the end date based on the projected hours. I would…
-
Countifs multiple fields and values
I"m trying count projects that are in IT Org (column) and are in project states (column) of New, Awaiting Endorsement, Project Analysis, Financial Review, ITSC Approval. COUNTIFS{IT Org Sheet Reference}, "IT", [{Project State Sheet Reference}, "New"...??How do I do counts of all other project states?
-
Can anyone help with a formula to count distinct entries that are not "N/A"?
So far I have been able to count distinct but have not been successful in excluding the "N/A" value. Any help is greatly appreciated.
-
CountIF with Criteria including date range
Hello, 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: =COUNTIFS([Issue Type]:[Issue Type], "Story", Labels:Labels, "Groomed", Status:Status, "To Do") However, when I…
-
SUMIFS/COUNTIFS Function: Total values but filtering out particular Status' AND Dates (Years)
Hi All, Firstly, I'll be honest and say I'm unsure whether this is a COUNTIFS or SUMIFS function but leaning towards the SUMIFS function based on my understanding of it. I'm trying to run a report to show the numner of (Column: Status) Closed Won and Closed Lost opportunities and the (Column name: Value) total value of…
-
Managing Testing with Automation Waterfall Notification and Showing Status with RYGB Balls
I 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 from one location to another and we have multiple IT groups that need to test the…