-
Character limits on Column Properties
Hello, I am new to Smartsheet and require an urgent help on the following issue: I have set up an "Approval" and "Update" workflow for my form, so I receive correct email notifications based on workflow triggers. However, in the email, the questions (column headers) are not fully displayed in the form due to character…
-
Restrict form dropdown selection to subset of column permitted values
Hi all. I'm trying to accomplish is I want to restrict a form drop down to a subset of the values that the corresponding sheet column permits. For instance, let's say the column in the sheet allows values: red, green, blue. However, I want the form to just allow red and green. I can't seem to make these restricted values…
-
IF and AND
IF(AND(Status1 = "Complete", Status2 = "Complete", Status3 = "Complete"), "All Tasks Complete", "Tasks Incomplete") I would like to know if it is possible to pull out the information from the column instead of a "text" i.e: =IF(AND({5S Audit Score Entry Range 5}=[Cell Name]@row1,{5S Audit Score Entry Range 6}="4", {5S…
-
Our newest template set, Vaccination Tracking, has just been published to Solution Center!
If you are a healthcare employee we encourage you to join our Healthcare Community Group where updates like this are posted. Details about the new Template Set: Organizations authorized to administer vaccinations during a period of great demand face an uphill battle; the requirement to precisely track, manage, and report…
-
Why does the message in my Workflow Email repeat?
I have created a workflow to send an email to the task owner when the task becomes past due. The task owner may be responsible for multiple past due tasks. When the email is generated, the message is repeated once for each row that met the criteria for the email. See attached screenshot for an example. How can I fix this?
-
Is there a way to format a calendar so that the full description of a task isn't cutoff?
Is there a way to format a calendar so that the full description of a task isn't cutoff?
-
Message Only Notifications with Attachments
Hello, I am trying to send a notification with the Message Only setting while including an attachment that is linked to the row. The primary goal of this is sending the notification without sending a link to the full datasheet to an external contact. Any assistance would be appreciated. Thanks!
-
Can I use an If and lookup formula in one formula?
I have two formula's that work separately and cannot get them to work together. I have a formula that returns a $ figure with this formula. =LOOKUP(Level@row, [Sports Level]:[Base Rate], 2, false Then I have this formula which returns a $0.00 with this formula =IF([Mobile Unit Base]@row > 0, "$0.00") I am trying to get…
-
Error when creating login
I have been sharing our project plans to customers with their permissions as a viewer. I have a customer who is receiving the attached error when clicking the link to create a login. I did delete her as a user and resend the user invite, but she got the same error.
-
Publish Calendar with Filter Applied
Hi I am trying to share a publish link and to embed a published view of my Calendar with a filter applied. This is the view I'd like everyone to see as the default. The filter keeps getting turned off. Any way to make it stick? Thanks for your help! Ilene
