Hi Community! I've gotten pretty far with developing a new tracking process for our marketing teams by scouring the questions and answers already posted here. However, I'm stuck on something that I haven't been able to figure out and am hoping you guys can help me brainstorm a way to solve it. I'm using smartsheet to track…
To share back with the community here, I'd like to share some key formulas that I've been helped with by the community and extensive testing/fixing. I have a sheet that tracks: * progress for items based on user inputs of %age complete * compared to the progress they should have completed so far (%age expected as of the…
My department manages the production of a quarterly magazine and uses SS for the editorial/content management process. Here is the sheet we currently use: https://publish.smartsheet.com/c95e42926fad4be7ae3463eaf2b228da I'm wondering if this seems like the best process, or if there's a simpler solution to a project that…
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.…
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…
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…
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,…
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.
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?
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…