-
Logic formula for checkbox
I am trying to get a box checked if a completion date has been entered OR a status has been marked complete. Formula I have is =IF (Status3 = "Complete") OR NOT(ISBLANK([Real Completion Date]3)),1 What am I doing wrong here?
-
Trying to add a IF date around a countifs statement...
My goal is to only count " =COUNTIFS({ZenQ Testing Required}, FIND([Primary Column]3, @cell) > 0) " if the date is within 2020 year for the created date of the jira ticket. Can someone help?
-
Help IF/AND formula with RYG conditional formatting
How do you create RYG symbol formula that requires multiple conditions of multiple reference cells? Here are the conditions I'm trying to write a RYG formula for....using reference cells [LEADER NAME] and [RISK FLAG]: If [LEADER NAME] = BLANK, then keep cell empty If [LEADER NAME] = NOT BLANK, AND [RISK FLAG] = CHECKED,…
-
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…
