-
Show icons for proofs and attachments in board view
Hello! Can we please add the attachment and proof icons as a default in board view? My marketing and creative team is used to the card view for projects. They keep thinking that projects are missing attachments and proofs since the icons are not visible in card view. I have been advising them to switch to card view or…
-
Set Different Working Days For Specific Tasks Within Same Sheet
I'd like to have different working days for different rows/tasks within the same sheet. This is a feature available in MS Project where you can use multiple calendars and choose which calendar to use for specific tasks/items. This isn't currently possible in SmartSheet. Some tasks exclude weekend work (typical office…
-
How can you calculate new date off of date fields?
I continue to get an error #INVALID COLUMN VALUE with my formula below. I have two restricted date fields RFP Decision Date and Actual RFP Award Date. I want to add the Estimated Approval Time, which is a number days value to the Actual RFP Date or if that is blank the RFP Decision Date, where we have a value in the…
-
Embed a published smartsheet calendar onto dashboard
I am trying to embed a published version of a smartsheet calendar on a dashboard but I need it to stay on a certain filter once it is embedded. Is there a way to do this? When I try this - the filter has not been "sticking". And just fyi - the majority of the audience that will see this does not have a smartsheet license…
-
Exporting Attachments to Google Drive
Smartsheet is very useful for collecting data through forms from non-users and organizing it in a database, from which automations can be run. The "generate document" automation is one I use particularly frequently. It's very helpful in making "receipts" of the most crucial information for other parties to review in a…
-
One-time pop-up Confidentiality Acknowledgement?
I use Smartsheet as a virtual data room, with each Workspace dedicated to a specific project. I will then invite different downstream colleagues to the project sheets. I would like to set-up a Confidentiality Acknowledgement statement that the colleague has to click on "Acknowledge", before being granted access to the…
-
Multiple File Upload Fields on Forms
It would be helpful to have the option for multiple file upload fields in forms, for example for photos, so that they could be associated with particular responses and not grouped together.
-
Data Shuttle Reorganization
Hi there, We have +400 data shuttles currently. 3 per project and 100s of projects. Is there a way to organize these. I was thinking of restructuring our way to shuttle data in for these sheets. Would it be possible to data shuttle into a template (parent project sheet) and redistribute somehow to to the child sheet. There…
-
Automation w/ nested If, Then, Else capability
I have a worksheet where every line is one of four "types". Once each line is worked and completed I move those lines to an "Archive" sheet based on their "Type". Currently I have four separate automations that move a single "type" to it's respective worksheet. The way I see current automation possibilities only allows me…
-
Sharing to unlicensed users
We need to share a couple of sheets to unlicensed colleagues for viewing and minor editing. Can you advise what’s the best way to handle this? Should we: Ask them to create their own free accounts - what is the downside of this? Is there an “expiration” on their account and will they no longer be able to view/edit sheets…