-
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…
-
Webform Submission issue
We are currently using our own custom WebForm to submit directly to Smartsheet. This process has been working flawlessly for the last few months. We had had users reporting now that when they hit submit on our php WebForm the old Smartsheet WebForm pops up and is completely blank. However if we go into Smartsheet, all the…
-
Updating a current formula for a report in a widget to include dates
I have an issue where the current formula feeds into the report correctly and displays on the dashboard widget however, I have now been asked to change the formula to be date specific. I need to have this display by our fiscal year (July 1, 2018-June 30, 2019). Pro-desk gave me the formula to copy and paste but the…
-
Auto-populating dates
I have several categories in my 'Status' column. (Sprint Backlog, Planning, In Progress, In Review, Changes, Print Files Ready, Print Req Sent, With Printing Services, Complete, Blocked) I would like to have a date automatically populate when the Status becomes 'In Review'. Then, once that date is populated, and if the…