-
QR Codes/Bar Codes
Dear Smartsheet Community. Is there a means within Smartsheet to allocate a unique QR/Bar Code to a specific line in a grid, such that if you subsequently scan the code (outside of Smartsheet), the specific line/data record can be accessed? For now, I am thinking of an image of the relevant code added in a cell as an…
-
What does "in the next 45 days" mean in an automated workflow condition?
Hello, I am trying to figure out an automated workflow where the trigger is everyday at 8am and the condition is where a [Date Column] is in the next 45 days. I have many rows in the sheet that each have unique dates and emails to contact when 45 days prior to that date is reached. My question is: does "in the next 45…
-
Column Titles Appearing in Metric Widgets
I was recently building a dashboard and found that column titles were appearing in the metric widgets I was creating. Usually this widget would never such column titles. It was whatever was selected in the reference sheet. Does anyone know how to fix this? I do not want column titles showing up in these widgets. Example…
-
Ich möchte Zeilen mit verlinkten Zellen (incl. aller Links) in ein anderes Blatt kopieren
Ist es möglich beim kopieren von Zeilen zwischen zwei Blättern, Zell-Links ebenfalls zu übernehmen? Über den Befehl "In anderes Blatt kopieren..." gehen leider alle vorhandenen Verlinkungen im Zielblatt verloren. Vielen Dank für Tipps und Tricks, Miranda
-
What size image, width x height, is best for a background logo on a form?
Has anyone discovered the right dimensions for an image to best fill a form background? Is it conditional on form-factor? dm
-
WorkApps User Management
It would be very helpful to export a list of people/emails shared to a WorkApp and their role to match up to company lists. We use groups as much as possible but we still have a ton of others listed. It's difficult to scroll through - it's not even alphabetical (that would also help). It would also be amazingly helpful to…
-
Status Rollup Automation Becoming Invalid
I wanted to automate status rollups for parent rows. Via the forums I found this writeup (Solution to Automating Status Rollups - Quip) and followed it exactly. It worked great. Recently for some reason recently every time the "Auto Status Rollup 1" automation kicks in it ends up giving me the "A workflow has become…
-
Help with COUNTIFS
Hello, I am trying to make a smart sheet in the same way as this example template. Form>collector sheet>metrics sheet> dashboard. Basically, I want the end result to be four different graphs tracking monthly results of yes, no, n/a, or other questions. I will include what I have so far and what differs after this example…
-
Change in Report Summary Function
Was there a recent change to the summaries function in a report. In my example below the summary count would only calculate if the box was checked. For example the adj approved count for this section would be 1 and the count for adj rejected would be 4, instead of it counting the total rows for both. Is there a way to…
-
Calendar View is Defaulting to Created Date and not current month
Hello I have an Events sheet that only has one date in the sheet. When we go to open the calendar view, it opens to the month the form was created and not the current month. I can't seem to change this. Is there a setting I am missing?