-
Request Snapshot not received. I am the sheet owner. Not on spam/junk.
I have requested for a snapshot, but I have not received the email yet. Any idea why and what do I need to do?
-
Rows Not Copying with Checkbox
Hello all, I am currently building a dispatch calendar/tracker app for my company. The idea is simple, if any task requires the assignee to be at the location, check the box labeled "Onsite" and the task is copied to the calendar sheet. The issue is, checking the box does not copy the row. If I run the automation manually,…
-
Update Request - Unable to determine your identity
I use update requests to gather information from my stakeholders. Recently, several users have been experiencing an issue of "Unable to determine your identity, therefore we are unable to process your request. An unexpected error has occurred attempting to process your request. We are sorry for the inconvenience." I use…
-
Speedometer Chart: Core Product
I've noticed a few people asking for Speedometer Charts in Smartsheet, so I figured I would go ahead and publish this solution that I developed. It was some years ago, so there may be better ways and / or more efficient formulas, but this should at least help get everyone started… A few notes to kick things off… This…
-
🆕 WHAT DO YOUR DASHBOARDS LOOK LIKE?
we need some creativity from others on some of the awesome dashboards people have created. please share some of the best of the best that you have!! hoping to spark some ideas… here is one of my recent ones - thanks in advance
-
Duration based on time - formula question
I was able to create a Smartsheet column with time included with the date (Thank you @Paul Newcome & @Akblevins ). I want to add another column that just shows the time - I used the AI Smartsheet feature to create a formula but receive an error message. Any ideas on how to correct? TIA!
-
What to do when contacts in a cell are higher than 20?
Hello, my request form allows individuals to select teams that will participate on a project. And for each team, there may be multiple emails associated. My email list can grow quickly from from a few for some small projects to 50 individuals for larger ones. I have a datamesh running that copies the cell containing the…
-
Help with a formula or formuals
I have 3 columns: Vic By plate number and model, Date Driven(Date Field), and mileage. I am trying to fina a formula or formuals to allow me to see the difference in milage since the last time the plate number has driven. Bonus: In 1 month. Trying to find an easy way to see priority of which vehicle needs to be driven next…
-
Hubspot Deal Amount & Smartsheet Column Formatting
When we try to link Smartsheet to Hubspot our bid amount column (text/number w/ currency formatting) is translating over to Hubspot as a string instead of just numbers. For example $10,000 comes out as "10000". Hubspot just wants it to show as 10000. We have tried removing the currency formatting on the Smartsheet side and…
-
Limit Form Submissions to a specific email type
I want to create a Smartsheet that only allows certain domain emails to submit, or even a specific list of emails, to submit a form WITHOUT logging into Smartsheet. Right now, the safe sharing list requires a Smartsheet login to access.