-
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…
-
Update Requests
We have an automated update request created, however, when it is triggered it sends a link to update all fields that need updating to all contacts within the sheet - as a result they are not using it as they cannot see which action is theirs to be updated What we would like to happen is that the update for that row only…