-
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?
-
Round function within a formula
Hi! I am trying to round 2 numbers, multiply them and then take that sum and multiply it by another number. In excel it is =round(A1,2)*round(A2,2)*A4. I am having issues duplicating this in smartsheet. What am I doing wrong? I have rounded down the columns, yet when doing the calculation with out the round function, it…
-
IF Statements Date Range & Excluding Blank Cells
I need to build a status column that registers when any due dates in a project are nearing certain parameters. This is for projects that could have between 1 and 10 due dates. Formula at the bottom (it's a doozy). * Green if any due dates in a row are > than today(+7). * Yellow if any due dates are between Today(+7) and…
-
SUMIF(OR(???
I am trying to sum a column if either my Paid in 1st half in 2019 column is checked or my Paid in 2nd half in 2019 column is checked. I am trying to use a few different formulas without success. Here are a two that I've tried: =SUMIF(OR([Paid 1st half in 2019]:[Paid 1st half in 2019], [Paid 2nd half in 2019]:[Paid 2nd half…