-
Dashboard View (specific dates)
I have a dashboard that I would like to go back and look at what it looked like a month ago. As the project progresses, I'd like to continue to do this. Is this a feature? I also know I can export PDF documents and save those and I can go back and looked at the previous PDFs I saved. Can this feature be automated? I amโฆ
-
Status Column updating for Parent
I have a column "Current Status" that is filled in for each child row. I would like to automate the parent row showing in the following order If "In Progress" appears for any child, then show "In Progress" for the parent If "On Deck" appears for any child, then show "On Deck" for the parent If "Manage" appears (but no onโฆ
-
Sheets exiting folders overnight
Hi all! Wondering if anyone else has this problem. I have all of my sheets organized nicely in folders. Many of the sheets are shared (but not at the folder-level). Some days, I log on in the morning and everything is as I left it: Some days, I log in and some of my sheets have decided to sneak out of their folders into myโฆ
-
Contact List formatting from formula only showing email address
I've got a formula that pulls contacts from another reference sheet into a Contact List column, but it also checks an adjacent column for a value to transpose a would-be contact: =IFERROR(IF(Resource@row = "Eric R.", "erussell@email.com", INDEX(COLLECT({IT Requisition Tasks Resource}, {IT Requisition Tasks Task Name},โฆ
-
Anyway to change report columns to show as rows?
I have a report based on a sheet summary that I would prefer showed in rows, rather than columns - is there an easy way to do this? Ideally I would like the above sheet to show each column as a row so, when I use this in my dashboard users can scroll down rather than across as this would be the natural way to read this?
-
Is there a way to omit empty fields from being sent in a notification email?
When a user submits their form, they get a notification email with all of the fields they filled in - including fields they did not fill in. Can I configure the workflow to only send them the data for fields they have completed, and omit the empty fields from the email notification? An example email notification below: Iโฆ
-
Inserting Pictures in Rows on Smartsheet
When inserting pictures on Smartsheet each row has a picture inserted for the purposes of my work. The issue I have is the width of each row changes depending on the size of the image. This makes the Smartsheet look very confusing and messy. I want the Rows to all be the same width when insert pictures. Excel seems to doโฆ
-
EXCEL IF FUNCTION TO SMARSHEET
Hi, I've tried everything and I still can't make a formula work in Smartsheet. Formula in EXCEL: =IF(K269>0;IF(K269>J269;"DELAYED";"ON TIME");"") Formula in SMARTSHEET: =IF([Doc completed]@row > 0, IF([Doc completed]@row > [Deadline for doc]@row, "DELAYED", "ON TIME"), " ") So if document completed date is not empty, thanโฆ
-
Date format on email
Hello again, I have an automated workflow that sends out an email to a contact list and includes one of the cells in my sheet which is date. The way it is displayed in the email is MM/DD/YYYY although the cell format is MONTH DD, YYYY (i.e. February 5, 2021) Is there a way for the date to be displayed on the same format inโฆ
-
Project Plan
My Go Live task on my Project can only be executed over the weekend. All other tasks on the Plan are Mon to Fri. Is there a way of adding an additional "weekend" calendar for a specific task or restricting a task to a weekend/specific date? If there is a delay of a couple of days the aim is to move the tasks to theโฆ
