-
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
-
Form Confirmation Options
Is there a way under the Form Confirmation Options to show a confirmation message AND include a hyperlink to a Smartsheet? I see the box accepts HTML code, but it doesn't format correctly.
-
Automatic document archiving?
Hi, we currently use Smartsheet to house our policy and procedure frameworks. One of my colleagues have suggested considering a more capable CMS that can automatically archive old documents. Currently each policy or procedure are attached to an individual Smartsheet row. When the document is superseded we either leave it…
-
Ideas on transition between annual project tracker sheets
Hello, I am looking for a way to "connect" two Smartsheets that track a variety of projects (one for 2019, one for 2020). Curious to see if anyone has done this, recognizing that some work may extend into the next year, and if there are any lessons learned / pro-tips in creating and maintaining such a concept. Thanks for…
