-
Set a conditional formatting across the entire sheet that only affects the cell where the condition
I'm trying to find a way to do what I've done with spreadsheets before, but I am not seeing a way to do in Smartsheets. In some of my fields, there are instances where I won't have a value. I populate those with NA, and I'd like to turn the fill for those boxes gray automatically. Traditionally I'd do a conditional format…
-
Contact Columns marked Multiple Don't Populate Legacy Reports
I have 140 or so projects I manage reporting on and was excited to see that we could now do multiple contacts in our Assigned To column. However, when adding new projects with this feature enabled I noticed that Reports count those columns as different than other Assigned To columns without this feature enabled even though…
-
Two Columns Named 'Assigned To'
Hello. I have a report that pulls milestones from multiple project plans. I created this report from a template within Smartsheet. There are two columns named 'Assigned To' Can you provide any answers as to why they seem to be duplicated and pulling information differently? Note that I have multiple shared project plans as…
-
Sending as attachment with filters
It would be awesome to be able to send out recurring attachments in which the pdf attachment is based on a filter. For instance, if it was a construction schedule and I wanted to send out a recurring two-week outlook then I could send it based on my two-week outlook filter.
-
Reference the value of an active cell?
Is there a way to reference the value of an 'active cell value' in a formula or have a moving reference? The current example code and screenshot specifically call out the desired outcome by referencing each cell in a range. Example: Project1 will start in 2018, which is reflected on sheet 2. formula in column 2 row 2 on…
-
BUG?! - Inconsistent Date Format (US/UK)
I have a regular gantt sheet with start date / end date, which shows up in UK format on the sheet as per my personal settings. However, when I link to that cell from a metadata sheet that I am using for dashboards the date shows up in US format! I have another date format column which is for baseline start and baseline end…
-
Days since
New user to Smartsheets and the logic application from Excel seem to be getting me in trouble. Looking for an equation (Days Waiting on funding) that will check four columns (Estimate submitted 1,2,3,4). If a date is present how many work days (less holidays) have passed. I also want the "days awaiting on funding" to be…
-
Freeze a row?
Has anyone discovered a feature to "freese a row"? I'm aware of the freeze a column option but have not found a way to freeze a row
-
SmartSheet Calendar App
First off - love it. Totally has changed how we are communicating with internal project teams and external vendors. What isn't working that great: Speed - super slow to access Email Comment Notifications: it would be great if the email notifications could show the comment and thread (if any). Nice to be able to get a quick…
-
Dashboard Color
Any plans in the future for letting us update the dashboard background color to any color we'd like? I'd love to be able to use black for dashboard backgrounds, as well as the backgrounds of the widgets, so that when on TV sets around the office, graphs are floating in black instead of a white background.