Hello Everyone, My master data sheet has a column called "Date Opened" where the date is formatted as Day-Month-Year. I am creating a dashboard and want to create rolling averages. I would like it to …
Hello Everyone! I am creating an automation and am aware that an image cannot be included in the body of an automation email. However, I opted to have the image attached to the workflow email by inclu…
Hi Everyone, I was wondering if there is a way to sort queried data in descending order. I'm aware there is no explicit SORT function and the way I set up my data sheet, I am unable to sort the rows/c…
Hello Everyone! I am trying to create a formula that counts the number of times a condition is satisfied for each month/year. My sheet has a column "Parameter" that either has the value "OFF" or "ON".…
Hello Everyone! I am creating a formula that returns the ID if the item type is "Book" and the status is NOT "Sold". My current formula I was trying is: =JOIN(COLLECT({ID}, {Item}, "Book", NOT({Status…
Hello Everyone! I have created an automation workflow that functions as intended. However, there are individuals I want to be cc'd on the automation email rather than each individual receiving a separ…
Hi Everyone! Every morning, I receive an automated email in Outlook with a report that includes different tables. I am creating a Smartsheet dashboard and was wondering if Smartsheet has the capabilit…
Hi Everyone, I am using automation workflow to help send an email with various data after 2 cells have been changed. For context, these cells are in consecutive rows. Is there a way to use a workflow …
Hello! I am making a dashboard and am using a Rich Text Widget to include relevant contact email addresses. All of the emails I included appear as hyperlinks in the Dashboard and the actual links incl…
Hello, I currently have 2 sheets that I am working with: the first is the "Original" sheet and the other is a "Metrics" sheet, which pulls data from the original (being used for Dashboard charts). The…