-
Blank display value for Symbols type?
I'm trying to recreate a switch function I've used in Project files to work in Smartsheet. It updates a symbol status column based on %Complete, Today's date, and Finish dates. I'm trying to use the green Up, yellow Sideways, and red Down arrows. Issue is, also need to display a blank in that status column if none of the…
-
Inventory Tracking
I'm trying to create a spreadsheet to track inventory for my business. It's very simple but for some reason, i'm having difficulty with the nested IF's. For example: the top of the sheet will list total inventory of wines; Merlot Pinot Chardonnay The user will select a type of wine, enter the quantity taken, and based on…
-
Formula involving multiple IF/AND statements
I need to modify the following formula to include additional AND conditions. =IF(Finished12 = 1, "Blue", IF(Target12 >= TODAY(+14), "Green", IF(AND(Target12 >= TODAY(+7), Target12 < TODAY(+14, "Yellow", IF(AND(Target12 < TODAY(+7),%COMPLETE>70, "Red")))) The additional condition would be in the third if and would be…
-
List totals
I have a sheet that lists all of our clients by project. For reporting, i'd like to see a final report or dashboard widget that lists the clients name in order of most mentions within the original list. For example: List A Joe Doe Freddy Mercury Alice Chains Eddie Money Joe Doe Eddie Money Joe Doe Report: Joe Doe - 3 Eddie…
-
Highlight If Older Than 'X' Days
I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days. It's helpful for us to see which tasks are stale. However, there's only an option for "In the last 'x' days" or "older than (a date)". Has anyone found a good workaround or submitted this as a feature request?
-
Prevent users from entering dates that put other tasks in the past
Our project managers are responsible for creating new projects in our schedule. They enter a install start date and contract date. The dates for all the other tasks are formula driven from the install date. The image below shows our engineering tasks. Those 3 projects where entered within the past two days. All of our…
-
Widget filter, IF statement, or what?
I have a dashboard that provides counts of certain data. One of the counts needs to be date-driven in the respect that it needs to show the count for the current year. How do I build that into the widget?
-
=SUM - Military Time conditional calculation Formula
Need help with calculation of military time: I have two columns that I am using to track Admission time and Discharged time to determine and average length of stay. I am using military time for each column and storing the difference in a third column for each row =SUM(([Discharge Time From ER]2 - [Admit Time]2) / 100) Exp…
-
Percentage of Total Tasked Complete
Good afternoon everyone! I am trying to format my "% Complete" column to auto populate when changes are made to my "Requirements Total" and "Requirements Complete" (i.e. If I have 10 requirements in my Requirements Total column and I have completed 5 in the requirements complete, which would make my "% Complete" column…
-
If(And) #unpareseable error- help
Hi I am trying to write a formula to check values in two columns to set a flag on or off. If I write them independently without the AND function they work but when I write it with the AND I get a #unparseable Error. Here is the formula- =IF(And([Planned Finish]@row > TODAY(), [% Complete]@row > "100%") 0, 1). Any guidance…
