-
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.
-
Customer Service
Does anyone know the best way to contact SS? I have been emailing for 2 weeks to get pricing and still have not had any luck. I need pricing to present the director when I propose using this sheet for project management but also don't want them to see the hassle it's been to get this going. usually this is the easy part.
-
Are you able to calculate minutes, seconds, and milliseconds in Smartsheet?
I have a sheet that I was able to calculate minutes and seconds using this formula. =VALUE(LEFT(Time@row, FIND(":", Time@row) - 1)) + VALUE(RIGHT(Time@row, 2)) / 60 Now I’m working on a form that needs to include milliseconds. I tried using the above formula and adding milliseconds but my formula returns an #INVALID VALUE…
-
Dynamic View - Conditional Formatting in Blank Cells
Dynamic View seems stumped by blank cells and doesn't properly apply conditional formatting. In the screenshot below, each of the white cells should have a color. As a workaround, we colored the entire column in the source sheet, which seemed to work initially. But then we realized that conditional formatting to change the…
-
Parent/Child Lines to be populated from Form
I would like to create a form that allows for Parent information to be completed and populated and where applicable allow for child data to be entered and applied to that parent data. Example: Form User Enters Main Task and Description and then has ability to complete further the Sub-Task and Description if needed. It…
-
Can't transfer ownership of a workspace
I've created a copy of my workspace and per the instructions I found at Transfer Owner permissions of a workspace | Smartsheet Learning Center, there should be a "make owner" option but there is not. I see only admin. This person has a license. I selected share at the workspace level, not file level. How do I transfer…
-
Validation Phone prefix countries missing
When adding a Field in a Form and adding a Validation Phone, there are several missing countries: Croatia, Indonesia, Mauritius, Morocco, Nigeria, Philippines, Serbia, Taiwan, Thailand, Turkey, Vietnam, Uruguay and others. Would it be possible to check and update?