-
Viewing Deliverable for Multiple Projects by Month - NOT in a Gantt : )
So...any creative ideas for how to achieve something similar to the attached image IN Smartsheet? We want to visual represent high level deliverables across multiple projects for the entire year by Month, however, NOT in a Gantt view and we want it as a 1-pager. Thoughts? Ideas?
-
IF Statement-If text is updated in my "Comments" within the last 5 days I want to return Yellow Sta
Looking for formula help. I have a comments column that I want to make sure is never more than 5 days old. If the comments field is updated with new or different information - I want to return a Yellow star to the Updated field or a date for which it was updated on. Is this possible? Thanks Molly Morton
-
Why am I only seeing system columns in Report Builder?
Hi, I am having an issue showing columns other than System Columns in the report builder. As you can see from the attached I have my sheet selected. What am I missing? I tried saving and going back in, but this did not fix this situation. Thanks, Paul
-
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…
