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 upda…
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 …
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 checkli…
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 ac…
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: "$" + $[Repor…
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 pas…
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 managemen…
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 s…
All I wanted to show you how I am using smartsheet to keep my budget reporting in real-time. I have 3 sheets 1) A Budget sheet 2) An Invoice Sheet 3) A Project Action Log The purposes are as follows B…