-
Project Status Health Formula (Using Due Date, Today's Date, and % Complete)
Hello, I am new to SmartSheet, and I'm trying to create a formula that shows project health status using the color symbols. These are my parameters below. I've not been able to get any formula to work. I'd greatly appreciate any help with creating this formula. PAST DUE - Red: Today’s Date is 1 day after Due Date AND %…
-
With COUNTM I can determine multiple selections are made, how can I extract the specifc selections?
If I have a multiple selection column, like 'assigned to', where I can select some or all of the people, can I determine which specific people from the list have been selected (without using FIND or CONTAINS and looking for names one at time?
-
Formula to Activate the Empty, Quarter, Half, Three Quarter, & Full harvey balls in a STATUS column
This discussion was created from comments split from: Formula to Change Harvey Ball Color Based off of a Word. I'm struggling with this formula. I have a drop-down column called STAGE, where there are 17 stages listed. I'd like these options to activate the Empty, Quarter, Half, Three Quarter, and Full harvey balls in a…
-
Reference two columns to populate a third
Hi, I'm fairly new to Smartsheet and am stuck trying to figure out a formula. I have three columns; 'Due Date', 'Complete' and 'Status'. Due is a XX/XX/XX format, Complete is a drop down with 'Yes or 'No' and Status is blank. Here's what I need: If 'Due Date' is past the current date (today) and Complete = No, then Status…
-
Simplest way to update staff on onboarding tasks
My organization (a small physicians office) is creating a new onboarding check list via smartsheet. We want to update the staff on certain tasks they need to complete for new staff members going through the process. I've considered a few options but wanted to ask if anyone had an idea on how to do this. Thanks
-
Amount of Requests per Lawyer
Hello, I'm trying to find out how many requests a lawyer gets per month based on a few things: -AFID (Auto Fill-In Date) -Type of Request = FOIA -Lawyer's Staff name -Status (Red, Yellow, Green, Blue; However, these are not in as words, they're in as "Visual Symbols") This is what I have right now (changing name for…
-
Nested IF function
Hi I am currently trying to create an IF function that will mark a row as overdue if in the 'status' cell is "Paid" or "paid through urgent payment". At the moment i have it working for just one criteria, =IF(AND([Days Until Delivery]@row < 0, NOT(Status@row = "PAID")), "OVERDUE", "") where do i add the second criteria…
-
using a pull down option from a different sheet
I am looking to use one sheet (risks and issues) which I have created to track my small project risks and issues. I want all of them to be in one sheet as the projects are small and do not require a full risk and issue log on their own. I have another sheet with all of the projects listed in them, i would like to reference…
-
Nested IF's Question
@Shannon Heizenrader I am creating a post for you so that your question and whatever solution is found is public. That way anyone having a similar issue can find help and other people are also able to weigh in on a solution that may be a better fit. YOUR QUESTION: Hi, Paul,I am new to the community and using formulas. I…
-
Convert numbers to words
Hello, In an effort to automate our contracting process I am trying to convert numbers to words (preferably dollars and cents) for example $12,345.67 = Twelve Thousand Three Hundred Forty-Five Dollars and Sixty-Seven Cents. Using Google Doc/Smartsheet Merge I have completed most of the project with ease, however i am stuck…