-
Help with #DIVIDE BY ZERO error message
Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on some of the rows. The formula in question that is currently being used…
-
Teams Integration
Hi All, I have been tasked by my manager to incorporate SmartSheet into Teams. We have completed the integration and I can now see the shared sheets in Teams without issue. We would like to go a step further and be able to receive notifications in Teams when certain fields are completed on the Sheet. Is this possible?…
-
Adding all task participants to parent cell
WHAT I WANT TO DO: I need to add all participants of tasks to the tasks' parent cell (one time each, in case that's an issue). If there is a way to automate this, I would love to hear it. That's the long and short of it. WHY I WANT TO DO THIS: Why do I want to do this? Well, in an attempt to add parent rows to reports, but…
-
Auto-Number creating duplicates!
I am using an Auto-Number column in my sheet to generate a new Request ID with every entry. I noticed this morning that there are duplicates of the same Request ID in the sheet. This is a concern because the RQID needs to be unique for each record. There are two ways a record is created with the sheet. One is if a user…
-
Date Range Formula
Hello, I am having an issue when trying to return values like "FY22" based on a date range. What I need is that is the date is between FY 06/01/2021 and 05/31/2022 for it to return FY22, if not then x. I get #Invalid Operation, and I've tried many different ways. This is what I have now: =IF(AND([FY Eligible Date]@row >=…
-
Returning Task Name based on a MIN(COLLECT(range, criteria_range, criteria)) formula
I am trying to get the task name of the current milestone to populate a cell so I can use that cell in a dashboard. I have a helper column that counts the number of days until due, and can get the lowest number in the range that is >0, no problem. How can I return the Task Name of the row that I find my lowest number > 0?
-
HELP ON FORMULAS
I am trying to create a formula that will change the production status automatically. My [production status] column is a drop down box with these options "Roof Ordered, Roof Delivered, Roof Building, Roof Complete". My other columns are date columns, so when the column [Roof Delivered on] has a date in it I want it to…
-
=IF(AND formula returning "invalid Operation" error
I have several check box columns. When all are checked, I want to turn on a flag in another cell. I first tried testing two of five check box fields and Smartsheet returns "invalid operation" =IF(AND(COI:COI = "1", EFT:EFT = "1"), "1") What am I doing wrong?
-
Resource Allocation View by project button
So I've had a problem with no "resource view by project" button. Background information: I'm a proposal writer working on a Growth Operations team. I've been working with our Strategic and Business Performance Group to incorporate more Smartsheet into our operations. I've been entered as a system admin, licensed (trial)…
-
Combining multiple SUMIFS into one formula
I have used and tried each of these formulas separately and they work beautifully. =SUMIFS([Total Savings]@row, Lane@row, "IL5" =SUMIFS([Total Savings]@row * 90 / 100, Lane@row, "IL4" =SUMIFS([Total Savings]@row * 50 / 100, Lane@row, "IL3" =SUMIFS([Total Savings]@row * 10 / 100, Lane@row, "IL2" =SUMIFS([Total Savings]@row…
