-
Help with Sumif not recognizing criteria as a percentage
Hi all, Trying to create a field that will tell me what percent of a list of values have exceeded 80%. =SUMIF([Goal Progress 2017-2018]3:[Goal Progress 2017-2018]7, ">80%", [80% Value Forumula Use]3:[80% Value Forumula Use]7) Goal progress is a percent value i.e. 100% or 45% 80% Value is the number 1 Smartsheet is not…
-
Formula & Conditional Formatting Update in Reports
I have several smartsheets that have formulas and conditional formatting. These smartsheets are pulled into a summary report. The formula's and conditonal formatting do not update when opening the report. Each sheet must be opened individually in order for the formula's and conditional formatting to update.
-
Formatting Parent Rows
Is it possible to format a parent row based on the number of children rows under it? If so, could you take it one step further saying like, highlight the parent row green if there are no children rows, yellow if 1 and red if 2. etc Thanks
-
Conditional Formatting using python API
Are there any examples of adding conditional formatting to a sheet using the python API? Google search did not turn up any. Thanks, Paul
-
Highlight Changes with a unique color, shade, or pattern for each user
I would like to submit an enhancement request for the Highlight Changes feature. The tool currently shades cells with a background color if a change has been made in the last seven days. Unfortunately, the same color is used for changes performed by everyone. I'd like to request the ability to customize the background…
-
How do I auto check a box based on a date + x # of days?
Can I get a box to auto check (so a conditional format is triggered) based on a date + 4 weeks? I want the sheet to auto tick a check box for me when something is 4 weeks past a specified date column. I want that to also correlate to another column that has a full harvey ball or % value of 100 or even just another tick…
-
Creating a Cash Flow Model
Dear Developer I would like to know if any one be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers etc. I…
-
formula to distinguish decimal versus percentage (i.e. 1 versus 100%)
I have a report that combines many sheets. Sometimes the values entered as 1 rather than 100% (or .75 rather than 75%). The report is an input into Tempus (Smartsheet partner) and it makes a difference to their application. Is there a way to determine that a value is NOT a percentage? Or require entry of a percentage, or…
-
Notification sent on selection of certain criteria from drop down menu
I have a sheet with a simple drop down menu. I have a notification set up for my accounting department. They only want to be notified once the "accepted" choice from the drop down menu is selected and not the other 4 choices. Is this possible. Thanks in advance Louise