-
Search/Find Column Titles
Finding one specific column out of hundreds can be a real challenge sometimes especially if you are not the one who built the sheet or if columns have been moved around. Being able to search for column titles using CTRL+F (or really any other way of searching within SS) would be a HUGE time saver.
-
Is there a best practice formula to use for this scenario?
I'm attempting to grab the value circled below on a daily basis and feed into in a master spreadsheet. I'm using a MAX formula in the latest record to help me capture the relevant record. It would feed into this spot in my other spreadsheet My thought is to do a formula to say if latest record is checked, grab value in…
-
Percentage Complete Function
Can someone help me with the formula/function for this - looking to put it on a metric sheet for the dashboard to pull from: 6 tasks (Taks A-F) divided by Comple from Status column to get percentage of project done.
-
Dashboard widget layering
Hello I want to add a map (image widget) on my dashboard then use either a metric or text widget to layer on top of my image widget. Is this an option. Is there another work around? For example i have a map of Australia i want to add to our dashboard, then i want to use text box widget to point out areas in Australia. If…
-
Copy Row Automation to not include Attachments
Hi Is there a way to copy rows via Automations to EXCLUDE attachments? I know this is possible when manually copying to another sheet. Can you do this with Bridge or via the API? To exclude attachements when copying rows. Thanks you in advance. Regards, Pierre
-
Unable to embed 360 tour to Smartsheet dashboard
Hi, I'm trying to embed a Ricoh360 image tour on a Smartsheet project dashboard. I'm receiving an error "unfortunately we could not find any embeddable content in this link". I have tried both iframe and html. I know the link is correct since I'm able to embed in my website and other platforms. Here is an example of a…
-
Arrow keys, tab, date
Hi, usually I can use the arrow keys or the tab button to scroll between cells. I can also usually just add say 10 into the date cell press enter and it will automatically move on. I am using the Smartsheet app on a MacBook Pro Thanks for your help. .
-
Ranking answers in a form
I'm trying to create a form where people would have to rank a list of choices from the most interesting and the least for them. Except from building a sheet with one column for each choice where people could put a ranking (then there's no validation if the ranking have been already assigned to another choice), is there…
-
Smartsheet form won't submit, get red message that there was an error submitting form.
Have tried submitting through incognito window, refreshed page and submitted, restarted computer than tried submitting, tried submitting through a different network all to no avail. Would appreciate any suggestions.
-
Authorization for Connected Users
There currently is not a way for System Admins to be notified of, and, approve or disapprove of a connected user in the Admin Center. Anyone that has an email on an approved domain has the ability to create a free account, whether they were authorized to or not, and becomes counted as a connected user for 365 days after…