-
How to deliver notifications by individual row after multiple row update
Hello Community! I would like to to have smartsheet deliver a single email notification or Microsoft Teams alert after a user updates multiple lines. Right now, I can update multiple lines on the sheet but only one email or notification is sent with the changes grouped together. I want the individual lines that were…
-
#INVALID OPERATION in my nested IF statement
Hi there Community! #INVALID OPERATION has me beat today. I believe the issue is somewhere in the bold area bc when I pull that section out I don't get the "#INVALID OPERATION" error message. The error is only displays when the row meets the criteria of the last IF statement ("Occupied"). When the logic is met for the bold…
-
Dashboard Preview
in Dashboard, i'm trying to compare the data preview between "Edit mode" and "Preview in publish link", i found the difference information time on "created date", please advise.
-
SUMIFs not working in Smartsheet VS Excel
I have the following table in excel if i use the function =SUMIFS($C$2:$C$5,$A$2:$A$5,101,$B$2:$B$5,"Approval") it will return the value of the approval date - 1/1/2020 however when i do this in smartsheet, the formula returns a blank. Does anyone have any thoughts here? Alternatively - would anyone have another solution…
-
Cell in child row display value from parent row (but different column)
Hi, I am having issues getting a formula to work to show the value from a parent row in a child row when the parent row value is from a different column. For the example below I would want a formula for the Associated Project column to always show the parent name in from the Project column. Thanks!
-
Countifs and OR statement
I'm trying to have a formula that will work if one column matches specific criteria and then if another column matches one of two criteria. I have been able to get it to work for one of the criteria from the second column by writing =(COUNTIFS({Assigned Owner}, [Assigned To]2, {Project Progress}, <>"Closed")) However,…
-
Calculate the total rows but exclude the same name
What kind of function combination that i can use to calculate the total row but excluded the same name, as follows (green highlight).
-
Report Builder - 'Who' Functionality
Hello, I'll preface this by saying that I think the answer is no, but I wanted to check for other people's thoughts. In our project plans, we have a Project Manager field that lives in a Contact type column. There are many projects we run where we have multiple Project Managers assigned. Each PM has their own dashboard for…
-
If a cell does not contain a period
Looking for the syntax for if a cell does not contain . (a period) This is not working =IF([Work #]1 <> "*.*", "No", "Yes")
-
MULTIPLE LINE (CHILDREN) IN ONE FORM
Hi. I am thinking of automating our Supplies Request using Smartsheet. Inside a Supplies Request Form, you can request more than 1 materials/supplies. What should I do inside a form to make requestor request more than 1 materials/supplies and make it appear in the sheet that there's only one SR form and under it (children)…