-
Multiplication with @row or @cell formula
I like to use the @row or @cell in a multiplication formula and be able to copy this for all months. where do type in @cell?
-
Announcing 24 New Formulas!
Each year, Smartsheet hosts a hackathon called “Hack the Sheet.” During this hectic, exhilarating, and productive week, our entire product and engineering teams get to work on projects they are super passionate about. We divide ourselves into teams based on interest, have some late nights, and are judged by peer and…
-
Generate reference after box ticking
Hi all, Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me. I have a supplier approval database with supplier info, several checkboxes for required docs, etc. Also have an approval column, and then an approval reference column. What i intend to do is, when i tick the…
-
Displaying range of dates on a Dashboard
Hi Smartsheet Community, My team currently utilizes a report with multiple sheets to track the due dates of projects. We currently use the Calendar app to display this info - but I'm looking to build an additional dashboard for my team that will utilize this report to display the upcoming due dates in a two-week window.…
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
Can I link an entire sheet into my master sheet?
It looks like I need more than Cell Linking in our master project tracker. Do we have the ability to add a section on our master sheet so that any updates from a separate MARKETING TEAM sheet is displayed in the master sheet? I'm afraid simple cell linking only focuses on cells and won't take into account additional rows…
-
Total sales dollars last 7 days, sumifs
I am trying to get a formula to tell me that total amount of sales for the last 7 days. Currently I have: =SUMIFS([ESTIMATED REVENUE]:[ESTIMATED REVENUE], <=today(-7), Date Released:Date Released) I have tried modifying it several times with no luck... Thanks, Kyle
-
Formulas
Hi, can anyone help please. I'm trying to change formula that changes the colours in the health column automatically when you change the drop down in State column such as complete, in progress. I would like to have the following Green – not started Yellow – in progress Red – when it goes past the due date Blue – Complete…
-
Using a modifier to derive month (formula de-bugging help
Ok. so I've set up a rolling dashboard built around the today function - something like this. Everything rolls over automatically as it all references TODAY() to determine the various derivatives. (see screenshot) It's great, but doesn't scale (yet). The Month column uses this right now - =IF((MONTH(TODAY()) + Modifier5) >…
-
Populate % Complete when Actual End is a date
I want to populate the % Percent field with 100 when the Actual End Date is entered. I tried this formula but I get an error. =IF([Actual End Date]@row > "0", "100", "0") Any suggestions?