-
Prevent Duplicates
Hello, I have a column name PO Number for example. This is a text/number column. The value I will enter in this column is unique and should not be repeated. Is there any way to accomplish this? Say I am entering Serial Numbers, and if I enter a repeated serial, or value, can smartsheet block it, or tell me I am entering a…
-
RYGG ball and task status formula based on % complete and due date
Hello! I am working on a column formula for a project plan where the RYGG ball and Task Status will automatically be updated based on the % complete and the due date. What I'm trying to solve for is: if % complete = 0 and start date is today or in the future, then stage is grey and status is "not started" if % complete =…
-
=Index(Collect(... Contains
Hello. I'm trying to return the "Flag" onto 'PS Bids Worksheet' from the 'Vendor File Nomenclature' (See 2nd snip below with blue highlight) page IF the Primary Column on 'PS Bids Worksheet' CONTAINS the description located on 'Vendor File Nomenclature', and it works great if there's not any additional words and/or…
-
Form entry data aligning with pre-entered data on grid
I track a lot incentive cards for my work. As I have began to use smartsheets, I think it will be better to track here. I purchase incentives in bulk quantities and distribute to staff to give to research participants. If I enter all card numbers into the first two columns as below, I am wondering if I could utilize a form…
-
WorkApp folders
please add folders to organize workapp items
-
Have you seen the profile data get unselected in a blueprint?
When I opened the blueprint, noticed that profile fields were suddenly unchecked. Have anyone seen this happen?
-
JIra-Smartsheet Connector
Hello All Just trying to figure out it if it is possible to create a Smart sheet workflow from Jira Cloud to smart sheet and within the workflow only connect it to a single ticket or Epic. We do not want it to pull the data in from the entire project. It is a Jira Work Management. Trying to figure out if there is an option…
-
Smartsheet burndown chart not appearing
I came across this link for a burn down chart template on Smartsheet's website (https://docs.google.com/spreadsheets/d/1ekfR_xE9YnDzrJxHCAjYDAFiGDqMEdBfSXGbIuN89rw/edit#gid=552825796) but then when I go to select "create in Smartsheet" it keeps telling me I need to login (which I have) and it won't show me where it's…
-
Auto populating Rows based on the number in the Qty box
Hi. Is it possible to auto populate rows based on the number I have in my QTY cell? I want when I enter a 3 in the QTY cell it automatically copies and adds those three lines. I need each of the in this case branding # to have their own lines and I do not want to have to put in all this data. Sometimes we have up to 100 or…
-
Automatic Comparision and automating the list of emails from two sheets into a third sheet.
Hi all, I have Registration sheet, which captures the email address. After registration, the individual gets email to participate in the challenge, with link to other Challenge form (and data will be captured into another sheet "Challenge Sheet"). Based on this email address column I have linked both the sheets, and as…