-
Last day at ENGAGE!
As a new user of Smartsheet I came without big expectations. Three years ago I new about Smartsheet I was like "Why I would invest time on another Grid based platform...". I am an Excel, CRM, ERP guys.. So I passed at that point in time. However.... This has been one of the most productive conferences I have ever attended.…
-
Very ENGAGING at #Engage2022
Having so much fun and learning all the things at Engage 2022 in Seattle!
-
Stumped on an IF formula
I have data in the following fields: Target Sales: Last Week's Sales: I currently have a formula that tells me if Last Week's Sales are less than Target Sales, then return "Yes" or "No" I need to update the formula to tell me if Last Week's Sales are less than Target Sales, are Last Week's Sales below more than 5% of the…
-
Stumped on a SUMIFS for Fiscal Year (FY)
Hello everyone, I am a bit stumped on a solution. I tend to not like to hardcode information into a formula. I was working through a solution to help manage a Business Development (BD) pipeline. With the help of the community, I figured out how to do a YTD. But then I was thinking that it didn't make sense to have the BD…
-
Roll over Monthly checklist
I am looking to create a month-end checklist which has list of activities and due dates and tracks the completion status driven by user inputs. What is the best way to a) archive the completed checklist and b) roll over the checklist month over month. The fields are consistent month-over-month with 80% pre-populated in the…
-
Cashbook
Hi, We currently use Excel for our Cashbook and there are tons of syncing issues. I was thinking of using Smartsheets but was wondering if anyone has an experience doing this? We have multiple bank accounts that need to have debits and credits accurately input. There are weekly and monthly transfers between accounts and…
-
Convert Numbers to Text so I can show a range keeping the comma delimiters
I have two columns of data showing prices, say $1,100 in one and $2,200 in another. I want to display this as a range in a report as "Your price is $1,100 - $2,200". I used this formula: "$" + $[Report Low Price]@row + " - $" + ($[Report High Price]@row which returns "$1100 - $2200", how can i have it include the comma…
-
SUMIF Formula with Checkbox Criteria
Hello, I used to be able to use a sumif formula and pull in lines values that had a check box in one reference column or not checked in another reference column, and now that formula I used in the past doesn't work, I would use ...,{column Reference}, TRUE... ...,{column Reference}, FALSE... I can get around the issue with…
-
RYG Arrow Colors
I would like to recommend an additional option to swap the red and green arrows so that there is an option for red arrow = up and green arrow = down. This is helpful for budgeting in project management where at a quick glance you can see if we saved money on an item or lost money.
-
How do I create a predictive balance formula?
I'm not sure if this is even valid/possible, but I'm trying to create an accounting schedule which foresees upcoming payments and reflects the balance after the transaction. This image is a practice sheet with fictional values. In theory, I'd want the formula in Balance to always take the previous balance and add it to the…