-
Website Counter
Is there a way to add a counter to the Smartsheet Dashboard to count the number of times the dashboard has been viewed?
-
Read receipt
Good Morning, Is there a way that if I @someone on my smartsheet and it sends them an email that I can be notified when they click the link and look at the smartsheet?
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Alert a user when an automation isn't going to work
I have a sheet where there is potential for an incorrect email to be added via a form (SS requires an email be entered for it to populate correctly into a contact column if not in the SS directory-if you have a fix for this, I would love it!). As the owner, I am notified when a user will not be alerted due to an incorrect…
-
do not run formula if cell is blank
Hello, I am a new Smartsheet user. I have search some previous inquiries on this topic and tried the suggestions but I cannot seem to get it right. What do I need to add so the formula will not run if the check-in and check-out dates are blank? =NETDAYS([Check-In]1, [Check-Out]1 - 1) Thank you so much for your help.
-
Formula to create hyper link with display text defined
I want to be able to clean up/simplify how a link is displayed in a cell. Column A: the text I'd like to use for the link display Column B: the long URL with lots of URL tokens, folder locations, etc.. Column C: a clean, short, hyperlink made from A&B Example values A: Profile B:…
-
Smartsheet for Inventory using QR codes
Hello everyone, I'm a teacher who has to manage a "MakerSpace" - a design studio with lots of electronic equipment. It would be ideal if I could place a QR code sticker on an object, take a snapshot of it with the camera on an ipad, and arrive at the inventory Smartsheet that I've created where this object's original…
-
Formula to look across rows and columns in a table.
Hi there I need a formula that will look across rows and columns in a table. For example, I need the result for School District-B with 23 items. The result from the table below should populate with: $350 1-5 6-15 16-25 26-50 51-100 100-50000 School District-A $100 $200 $300 $400 $500 $600 School District-B $150 $250 $350…
-
How do I add text to the end of a formula?
I have a formula that calculates the number of days and would like to add the word "days" at the end of the formula. In Excel, I would use '& "days"' as in =NETDAYS(Added1, Closed1)&" days" ...
-
Can I edit the URL for a web form?
I see that the URL is editable when you click in the box where you can copy and send the URL to someone. Is it only editable so you can copy it, or can I edit the URL to be more descriptive and shorter? If so, how does it get saved? Thanks, P
