-
Image as map input
Hello, Is it possible to use an image as a map to either click to input coordinates as x and y values or to plot the coordinates back onto the image? I've done lots of searching but can't find anything. I want this feature to mark locations on a site plan or equipment drawing. Not a Google map. AppSheet does something…
-
Help with Average Formula
Hi there - I'd like to ask for a hand to calculate an average formula. This is a cross sheet formula where I want to aggregate an average time duration by Assigned To, by quarter. (I also have instances where my time duration is zero - I think that was causing me a divide by zero error). Metrics sheet/destination: Source…
-
changing color of milestones
I would like to have a certain milestone diamond in a different color (let's say red). I tried to do it by using conditional formatting (the condition being the milestone name), but it doesn't work. Any suggestions?
-
Email flow at row level + checkbox
Hello, new user here. Is it possible to set the notifications flow at row level? I need to send emails from Smartsheet when a check is added in a checkbox column type but only for that specific row, not for all other rows that already are checked. Currently the flow is including in the email the data for all rows that meet…
-
Is it possible to automate a work flow that sorts rows by date when a sheet changes?
I have a sheet that I pull reports from into a dashboard. it would be great if the most recent rows sat at the top of the sheet. Currently I have to manually sort the date column.
-
Formula for calculation
Hi Guys, I'm stuck with one critical problem, where I need one formula. I have two sheets Sheet A (contains only applied leaves, not all the dates range) Column 1 - Leave Start Date, eg 01 jan 24 Column 2 - Leave End date, eg 03 jan 24 Column 3 - Employee code, eg ABC001 Sheet B (contains entire range of dates for…
-
Document Builder
Hello, I have a cell in Smartsheet that has multiple paragraphs worth of text but I can't seem to line up the paragraphs by pressing "ALT ENTER". It will create a space between the paragraphs in the cell in Smartsheet but it shows up as one big paragraph in PDF. What I want Paragraph 1 (Enter Space) Paragraph 2 What the…
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
Change DocuSign Account
Using the generate document feature, can I change the DocuSign account on the mappings without losing the mappings to the fields? I just need the sheet to use a different DocuSign account and I don't want to have to remap the 50-60 fields. Please tell me this is possible.
-
How to reopen Worskpace Panel
I closed the Workspace Panel so it wasn't blocking my sheet columns. Now I want to reopen it but I don't see that option. How do I fix this? Also, I uploaded logos to various Workspace to distinguish between clients I am working on. Now that I closed the Workspace Panel, I no longer can see the logo.
