-
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.
-
Scheduled Reports Not Generating
I have set up several recurring scheduled reports to be run this week, and NONE of them have run. I am using the "Send as Attachment", "PDF", "Schedule to send later or on a recurring basis", I set it up, then hit "Send", and the recurring event appears in the "Sent to" field with the circular arrow icon to its left, but…
-
Percentage Complete Calculating Differently on 2 sheets
I have a smartsheet that is pushing data to another sheet. Percentages complete are part of the data that is being pushed. On the source smartsheet it shows 45% for a section. On the Target sheet it shows 63% complete for the sames rows. Can anyone explain why I am getting 2 different percentage completes calculated?
-
Exporting Gantt View to PDF
Hello, Is there a way to export a Gantt chart to PDF and also include an image in the file? Thanks! Andrea
-
if function for 3 criteria
Dear, I am planning to write an if function for 3 criteria. IF(AND([In Progress - Late]1 >= 1, [At Risk]1 >= 1),[In Progress - On Track]1>=1,) "Red","") I know I am writing it wrong. Can anyone help me structure the formula please? Cheers!
