-
Why would my workflow not be sending the notification
Hello, I am using the current workflow, but for some reason it is not sending the email notifications out. I have run tests to send to myself, but still do not get the email notification. I have checked the junk mailbox, but something is not working. I have other similar workflows that seem to work ok. This is just sending…
-
Showing Contact Names instead of email addresses in Contact Column in Sheet
This discussion was created from comments split from: How to show Contact Names instead of email addresses in Contact Column in Sheet?.
-
OR( ) for multiple criterion ranges within INDEX/COLLECT/SUMIFS
Hello, any tips for using OR for multiple criterion ranges? The formula below outputs #INVALID DATA TYPE. =INDEX(COLLECT({Task Name}, {Details}, <>"", OR({X Budget}, {Y Budget}), <>""), [Expense #]@row) The goal is to only pull tasks into the new sheet that have a value for either budget type (X, Y).
-
Time Related Email Notifications
Hi fellow Smartsheet users, I have a Smartsheet setup where it will send an email notification when items are coming due. This will trigger when a value hits 30 days in a specific column. I went and opened this sheet for the first time in a while today and it sent me a notification that the item was coming due but the…
-
Sending Request an Update email to 1 person with Multiple Projects
Hello, I have a projects list (one sheet) that I need to gather more information on. I have an automation set to send a Request an Update email when certain conditions are met. Since my list is newly created, I am seeking a bulk update on multiple projects to start. My question, is there a way where only 1 email would be…
-
Multiple photo upload
We need to batch select photos in our inspection form on our phone while on site, which then needs to input into the smartsheet, one in each column because then the information from the smartsheet once generated goes to a another page which collects all the data and inputs all the information collected on one page and the…
-
Possible to Display different report based on day of week in dashboard widget
I currently use smartsheets for weekly assignments for my staff. We have a group of reports setup to show a summary of their assignments daily. What I would like to know/accomplish is whether I can format a report that handles what the 7 we currently use all in one? To give some context I am reworking our dashboard to show…
-
Calendar View
Is there any way to display 2 columns in calendar view. We are a construction company, who is now using smartsheet for all our scheduling of sub contractors. I would luv the calendar to show the task Steel Delivery and the vendor/sub we use on the dates. Now we have looked at the calendar app and it is way to clunky for us…
-
How do you represent cancelled projects on your portfolio roadmap or timeline?
I'm tracking all of the initiatives we have going on with a report to show a timeline of everything. I'm wondering how best to show a project as cancelled. I have sheet with projects linked and also a similar report. I use the ghantt or timeline so we can visually see what's going on. When a project is started and…
-
Using a Cross Reference Sheet to update column using API
I'm looking to update a dropdown list referencing a column on another sheet using API. Reading through API documentation, it looked like I needed to create a cross reference sheet. How do I now use this new Cross Reference Sheet to update the column dropdown in my target sheet? Thank you!
