Discussion List
copying rows to RAID log
Howdy, partners - I'm trying to use the copy row automation to copy tasks into a RAID log when a user identifies a risk or issue in our Project Plan. Our plan has a few sets of parent rows, and I'm finding the copy automation is not bringing just the direct parent, but the entire sheet into the RAID log. This is obviously…
VLOOKUP and dropdowns
Hi! I'm trying to return a date from a VLOOKUP but the search is in a dropdown. It is saying no match despite the name being in the sheet. Does my information have to switch out of a dropdown for this function to work?
Create your own Automation templates
Hello, It would be so helpful if I could create a automation template that I could use across all my sheets. Right now i have to re-create the automation for each of my sheets. I wish i could just copy my automation from my other sheet or create a saved personal template. Thank you, Peter Taylor
Rename Hyperlink in Automation Workflow
The the automation workflow, is there a way to rename the hyperlink that shows the row number (see screenshot: Row 193) to something else?
Conditional Formatting- Color Change
I am needing to add conditional formatting to my sheet to change the color of a row if it was added within the last 30 days. How do I do that?
Workflow Delivery Alert Email
I received a workflow delivery alert letting me know not all recipients received my automated notification. In the email, I can see only the top 6 users out of 16. How do I get/see the complete list of impacted users? Thank you in advance for your help.
30 Days or more + Every status except for one
I am looking for a count of rows that have a date before the last 30 days [Last Date of BHL Contact], and the status in [BHL Appointment Follow Up Status] is anything except for “Appointment Attendance Confirmed” I have tried many variations of =COUNTIFS([Last Date of BHL Contact]:[Last Date of BHL Contact], >=TODAY(-30)),…
Detailed interactive chart widgets
Within a dashboard, I have several charts with bar graphs displaying certain categories of data. There are interactive widgets, so when clicking them, the detailed report loads. The idea is to have Smartsheet generate a level of widget interaction where clicking on one specific bar graph would ONLY load that data group and…
How can I edit the font size of a dashboard Graph series value? (See image below)
Report Column Header Color
It would be helpful to change the color of either the font &/or the cell in Report column headers. Thank you!