-
Set Workflow to a specific cell/row not the column
Hi! I'm trying to set up an automatic workflow that will trigger an email alert to a person when a particular cell has been populated but can only seem to be able to do it for a column and not a specific row. Example is: Person A is assigned a client. When Person A completes Task 1, Person B is to Peer Review that…
-
Efficient Formula for Sheet References?
Hi, Complete novice here so please excuse my crude description of what I'm trying to do! Also if this question is already in the forums somewhere apologies, I'm not entirely sure what the correct terminology is so I do not know what to look for. I'm looking for a way to pull multiple sheets (training records) into one…
-
Formula to populate red, yellow, green balls
Hi, I'm looking for help creating a formula to populate red, yellow, green balls based on a compliance level. Any help is appreciated. Kindly, Jolene
-
Can Bridge use Smartsheet APIs with HTTP Call Utility Function?
Hi, I'm trying to manage some automated attachments of files to rows in Smartsheet. I've gotten to the point of retrieving the file from its source and am ready to upload it to a Smartsheet row via API. I also have this API request working in Postman. Where I am struggling is when I try to implement this API request in…
-
Calculate Working days with Multiple If Conditions
I have a scenario to calculate due dates with the following logic. LOW - Greater than - 7 days MEDIUM - Greater than - 4 days HIGH - Greater than - 2 days CRITICAL - Greater than - 1 day I have written the formula like this example - Low 7 days - Request Created On - 04/01/2024 will achieve the output date as 04/07/2024.…
-
Formula Help... I think I need SumIf, And
Hi! I have this table below. Basically, I need it to sum the approved budgets for any project that is not assigned to someone, AND is not ready for a final inspection. Thanks for any help!
-
How do I create dashboards for each of my department heads to see the tasks of their team?
I want to create 1 dashboard for each of my department heads to see all of their teams tasks across multiple sheets. (One for Finance, One for Implementation, One for Account management)
-
Formula to Join Cells that have Content (with Line Break)
Looking to see if there is a formula that would allow me to join cells into separate lines ONLY for cells that have content. Essentially I want to remove blanks somehow so it is just seamless data. In my example, when I use CHAR(10). It joins the cells, but leaves blank lines if nothing was filled in for a cell. Im…
-
Email Notification : How to Remove the "Personal Email" on the "Changes made by" details
I saw that there were recent updates regarding email notification we set up through Automation. We can now choose "Send from Smartsheet Automation" and "Send from my organization". Currently using the option "Send from my organization" and then the messages includes "Links to sheet and specific fields" option on the "Alert…
-
Multi Select Column to Show as Individual Rows in Calendar App
Hi! I'm trying to build a calendar for speakers assigned to a program. I really want to see a column of individual names and each program they're assigned to in a multi month view. The underlying sheet has the speakers in a multi-select column. The issue is when I have more than one speaker assigned to a program/row,…