-
Conditional formatting for parent/child Kanban cards
I have three parent sections and each has a few children. I'd like to have the conditional formatting of the task bar be different so if something is under Parent 1, it's got an orange card etc. I can't find a way to do that so it's automatic for all new rows added under a parent and would hate to add a repetitive column.…
-
COUNTIFS + and referencing two columns in another sheet
Hi - I am trying to reference another sheet with columns "placement or asset" and "designer" where I can reference the designer name AND when the placement column says placement and have it count this amount Below is what I have done, but it is not working =COUNTIFS({NEW Global Messaging 2018 Range 2}:{NEW Global Messaging…
-
IF Statement Help
I have a sales price database with one column for a retail price and another for a sale price. I'd like to make a 3rd column with a formula that populates the Save __% for our Marketing team. I made this formula which works with one small issue I'd like to resolve if possible. =IFERROR(("Save " + (ROUND(1 - ([Sale…
-
Sum of a column by cell color?
Not sure if this is possible or not. I was looking into conditional formatting, but didn't seem to find anything that would work. I simply want to get the sum of a column based on the color of the cell in the column. In other words, I only want to see the sum of red cells and exclude green cells. If this is not possible,…
-
Switching from a regular sign-in to "work account"
When we signed up for Smartsheet, I used their regular sign-in method. How do I switch to the "work account" method so I can use my Office 365 account? Thank you.
-
Budget vs actual calculation
Hello, I was wondering why the formatting of this document is auto-crossing out the actual calculation? Is it suppose to be doing this? Is there a way to make it not do this?
-
Report Builder, Using Include and Exclude on Same Column?
Hi, I was wondering if there was a way to get the Report Builder to filter both an include and an exclude in the same column -OR- get it to filter for an exact word or phrase. Example: Filter for a column is set to find all entries that contain the name "john" but that means that a bunch of listings that also contain…
-
Trying to get fancy with formulas - RYG with "AND" conditions
I'm trying to get a formula that will do the following: Give me a RYG result in a column, by looking at whether a project item has gotten close to the due date, compared to what the status is on that item. I want it to give a Red result if it is within a specific number of days of the due date and has less than 25%…
-
User-submitted forms: Is there a way to have email address and name be automatically added to my Con
I have an "Update Request" Smartsheet, where employees can submit a request via a form. The 'name' and 'email' fields are both required, so I'm capturing those fields on every submission. BUT even though someone enters an email address and name, I still have to manually add that person to my Contacts. How can I set my form…
-
CountIf Parent Hierarchy Column and Secondary Column
I apologize if this has been asked. I am trying to figure out a Countif formula combined 2 columns. Column 1 is a hierarchy level column in 5 levels (0=great-grandparent, 1=grandparent, 2=grandparent, 3=child, 4=child). Column 2 is a internal priority level with 4 levels (High, Medium, Low, N/A). I want to get count of all…
