-
Automated Workflow from Sheet to Diagram (flowchart, mindmap, org chart)
I am looking to utilize Smartsheet for hosting a document. I am looking to map some of the data in this document to a second sheet/document that is a diagram/visualization with boxes, arrows, and labels (similar to a flow chart, mind map, or org chart). I hope to have these documents dynamically connected so that edits to…
-
Max File Size Upload for Unlicensed User
Hi, we use smartsheet update request forms to gather/update information from one of our suppliers who are shared to our account as unlicensed users. Sometimes they need to upload a file. My question - is there a max file size that the supplier can upload as an attachment to the form. I've read elsewhere that it's 250MB for…
-
Today Formula
Hi On my Smartsheet I have a column called "Completion %" and another for the "Completion Date" I would like the "Completion Date" column to automatically display the date the "Completion %" is changed to 100%.. Would love some help if anyone has any bright ideas 😎 Thanks Bianca
-
Turn off "others are now viewing this sheet"
Hello, is there a way to turn off this notification or any idea what can be causing this, there were only about 8 people in this at one time? (see below) It ends up taking over the screen and makes it difficult to work. This is just a normal Smartsheet and reports/dynamic views/etc are not options for the type of workflow…
-
Is there a way to see who deleted a formula whose output was blank?
I have many formulas on my sheet, one of which keeps getting deleted in random rows throughout. The output is often blank to begin with so cell history doesn't tell me who deleted the formula there. And the sheet is so busy that the activity log doesn't help- since the histories of each row are fitted into 1 cell which…
-
From Address on Notifications
We have notifications set to go to a contact in a cell -- works great. The problem I have is that my name shows on the "From" -- so I receive messages from people that are not necessary. Is there a way to work around this? Can the email just come from Smartsheet (or another email address in our domain?). Thank you, Donna
-
Erase colors un smartsheet
Hi, I have several sheets were I have this colors in certain columns at the bottom of the sheet. I tried to change the color to automate or in color white and then I save it, but every time I open the sheet again they are still there, I don't know if it's because I used a default sheet and that's why they will always be…
-
Copying dates to another sheet
Hello Community. Today I'm looking for a solution to copy dates from one sheet to another sheet if they will occur within the next 30 days. I didn't want to use the Copy row Automation because it copies all the columns from sheet to the other and I can't select which fields I would like to transfer. What I have is a…
-
Form Headings - Automated
When I create a Workflow the pop up format allows me to insert a Heading that then appears at the top of the Form when any communication is generated. I can use that box to include the name of the Project for example, the title of my SmartSheet - Project XXX, Phase YYY, Location ZZZ. When I use the email icon at the end of…
-
Importing and exporting multi-select columns
Hi, I've imported data from MS Forms via Excel. There are several columns which contain data from multi-select answers. What is the best way to import these? I've done some of it manually, but I'm finding it difficult to verify with the original as when I export to Excel all the multi-select entries are concatenated.…