-
Index Collect criteria with MAX latest date
Hi, I've been hitting myself over the head for not 'getting' it, I think i'm doing the correct thing, but obviously since I'm reaching out, I am NOT ;) If you would be so kind, please enlighten me on my error. In a sheet summary I'm trying to do the following: =INDEX(COLLECT(ReportSummary:ReportSummary;…
-
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…
-
Document generator - Font/Data error
The smart sheet document generator is showing erratic values; it used to work fine previously; however, any new document generated now creates an error; if I type ABCD in the smart sheet cell and then generate through the document generator, it will show something like (e^pp^k or olp^ifb) instead of ABCD as desired. Any…
-
Subtract Invoice amount from Total based on Status, in Parent-Child relationship
Hi all, I am new to create sheets, but I am trying to create a solution to track forecasted invoices that need to be sent out. I want to put each invoice total separately and when the status is marked as "Complete" I would like to have it subtracted from the Contract Amount to show the Contract Balance. I set it up so the…
-
Upcoming Resource Management Webinar- Register Today!
📣 Exciting things are happening with Resource Management by Smartsheet! Join us Tuesday, November 19, to dive into the latest features we’ve launched in Resource Management, get your questions answered, and even hear about a top-requested feature we're about to reveal (🔎hint: it rhymes with “phase integration).” ⭐️ Secure…
-
Calendar App Integration with MS Outlook
Hi Smartsheet community, Having issues on setting up access to a Smartsheet Calendar App in Outlook. Just a quick clarification that this is a different the same question as setting up a sheet Calendar View in Outlook (answer for that found here). After logging into calendar.smartsheet.com, I've enabled "Publish" for my…
-
Filter function in Dashboard
I am building a dashboard using a report for the data source. I do not want the dashboard viewers to have to click on the widget and open the report to manipulate the filters. What I need is a way for the viewer to filter the data in the dashboard. Is that possible?
-
Group Columns in Grid
Hi! I use a really large grid-style Smartsheet to track all aspects of project development and health. It would be very helpful to have a way of grouping columns. The hierarchy for rows works great, but I think with columns I am just looking for a way to clean up my views. I feel like the best (and only) solution right now…
-
Formula help needed - if/then
Is there a way to make my formula (below) that if the "type of CPG" says "priority" in it that it can be - 21 days and all other types would be - 14 days? hopefully that makes sense!
-
Report totals formula
Hi, I have an example below. On my report, months remaining for each store is correct, based on inventory/sales pace per month. However, in the total, I cannot add the months remaining to get an accurate number, which the report is trying to do. (It doesn't work if any of the sales pace numbers are below 1. I need to…
