-
Copying/Moving attachments to other rows
Good afternoon, I'm not aware of a current way to do this, so I'm wondering if it's on the dashboard for enhancements. In our use, we find ourselves needing to attach/copy the same documents from one line to another and currently the only way I see to do it is to download the attachment and then upload to the new row (it's…
-
Dates in formula AVERAGEIF
Hello, I have problem with the dates in the formula below (in sheet summary) =AVERAGEIF([Date of request]:[Date of request], >07.01.2019, [Completed in days]:[Completed in days]) The Smartsheet returns me the value 0 that is wrong cause I have lots of numbers that meet this criterion. Please advise and thanks in advance
-
Report and Calendar View
I created a report from a sheet. The report contains only a few columns. This report is intended to be mostly used for calendar view. The items we want viewable in the calendar are the same items contained in the report -- not the main sheet. In calendar view, if you click on a scheduled item, all the details from the main…
-
Risk Register - download example template
Hi - I am trying to download the very first risk register template that is referenced on this page. https://www.smartsheet.com/risk-register-templates When I click the Smartsheet version, I get a completely different Risk Register. When I select Excel, I get the one pictured. I tried to download the Excel version and they…
-
Automating RYG balls to change colors
So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have a green ball, I want the ball for the parent to be green If all dependencies have a…
-
Conditional Formatting
I am using a form to collect contact information for event registration. We want our guests to register separate email and phone numbers for each member of the household. Is there a way to create a conditional format that keeps guests from entering the same phone number and email more for more than one person? Thanks, d
-
At Risk Flag
Hi there! I am trying to have it so that the flag shows if the End Date is 3 days away AND the Status is "Not Started" (ideally, I would like it to show if the status is anything but Completed, but that may be too difficult). I know to use a nested IF/AND function, but I keep getting errors when I write it out. I started…
-
Is having multiple 'events' on the same row or specific days highlighted possible on Gantt view
I'm creating a Gantt chart to monitor and plan my progress for a thesis I am writing. I have the various stages of my thesis with their sub-projects indented under them, so my Gantt chart is becoming quite tall. I also need the days of my other deadlines highlighted on the Gantt chart, so I can see where my deadlines will…
-
Fixed Cell Reference
I have search the db for answers but likely have my terminology mixed. I have a sheet which is populated by clients via a web form. New entries appear on the 1st line. I want the value in 'Bears 1' to populate in another sheet or on the same, doesnt matter. The specific cell is key as this is the most current value.…
-
Sheet Roll-Up
I'm curious if there is a way to have a "higher level" sheet that pulls from other sheets. That way, each individual on our team can have their own projects with greater detail and our supervisor can see a higher level view of everything being worked on.