-
HELP with a large sheet and table layout/conditional formatting
I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel. I have 200+ sites that each has 31 activities. Each activity has 3 dates - planned date, reforecasted date and actual end date. I need a report that…
-
At Risk Formula Unparseable Error
I am trying to build a nested at risk formula based on the following triggers. -End date is today and Status is not complete it will trigger -There is not enough time between today and the end date for the duration period left. So, if duration minus % complete is 4 days. and the period of time between today and the end…
-
Different types of zeros?
The formula below is creating multiple "zeros". See pictures. What am I missing? =IF(Balance@row = "ERROR", "ERROR", IF(Balance@row = "TBD", "TBD", IF(Balance@row = "DEDUCT", "DEDUCT", ((SUM(Jan@row:Dec@row) + SUM(CHILDREN(Jan@row:Dec@row))) - (((SUM(CHILDREN([Contract Amount]@row), "Change") + ([Contract Amount]@row)) -…
-
Conditional Formatting Grid View v. Calendar View
I am new to SmartSheet. I have a column called "Conference Call." I set a conditional format that appears correctly in the grid view but not in the calendar view. I'd like the word font/color to appear the same in the calendar view that it does in the grid view. I am attaching screen shots.
-
Color Coding for Names / Owners only
I'm trying to find out if I can color code only the name bubble. For example, below I'm using the multiple-drop down column formatting and all names are shown in grey. It would be nice to show Whitney in purple, and Laura in yellow, so that they can quickly see tasks they are assigned to. Right now, I can only set a…
-
Gantt Bar Conditional Formatting not performing as expected
Hello Community, I am attempting to use conditional formatting to change the color of my Gantt bars; however, the conditional format is not being applied to the Gantt bars. Here is my conditional formatting You can see below that I specify a change in row color and Gantt bar color based upon values in booSummaryRow. The…
-
Create formula to count category risk with aggregate rating
Hi, I have a risk register for a project that has well over 100 risks documented and I have them categorized into 17 different risks. I would like to be able to create a formula to count how many risks exist under each category and then a formula to show the aggregate risk associated with this. I would think by a…
-
Conditional Formatting based on due date
I have a due date and want to have the "Risk" green if the due date is more than 15 days out and the Status is not "Complete". How do I do this?
-
Vlookup using Dates
Hello, I'm having some issues around a simple vlookup using dates. I have include screenshots to assist. My formula looks as follows and I am getting a "invalid data type" error. =VLOOKUP([Batch Helper]1, {Site Disposition - database (MASTER) Range 2}, {Site Disposition - database MASTER Range 1}, false) I am trying to do…
-
Smartsheet moving rows
Hello everyone, Bit of a strange one. I have a master list of parent rows each having several children rows. For some reason the order of children rows is changing. I have checked the activity log and no one is editing it and there is no conditional formatting so I have no idea why it is happening. If anyone has any help…