-
Using Project Management Templates
I'm using the PM templates and the templates utilize a section in the project plan that is called Project Information. It's handy b/c you can use this non-task related information in dashboards. What my issue is w/in the Finance section under Project Info - there is budgets and actuals. I am trying to utilize the children…
-
Populate a column based on a Smartsheet User Profile data
Is there a way to access the fields in a Smartsheet User Profile. I have an Assigned To column which can contain a single Contact List type. Each single contact in Assigned To is also a Smartsheet User. I have a corresponding Assignee PH# column in the same row. Is it possible to populate the Assignee PH# by doing a…
-
Cross-Sheet References with Contacts
I don't know if what I'm trying to do is not possible within the application or if I'm just missing something. I have created a form that the user selects their name from on the dropdown list. On the corresponding sheet, I'd like to populate their email address and office code by using a master contact list in a different…
-
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).