-
Formula to add X years onto a date?
Hi, I have a formula that adds 1, 2 or 3 years onto a date but the return date is going to the 1st of the month. Can someone please advise how to fix this so the date is exactly 1, 2 or 3 years later? Formula I have used in Next Review Date column =DATE(YEAR([Last Reviewed Date]@row) + [Review Frequency]@row, MONTH([Last…
-
Using a formula that involves different sheets.
Can you use two different reference sheets in a formula? I have a data sheet where I use a formula to add up my data (sumif backlogged money). Is there a way to write a formula to pull information from two different sheets to produce a result?
-
Link multiple rows from source sheet based on filtered dropdown
I have a contacts sheet listing 800+ vendors, speakers, & performers used for multiple events throughout the year at my organization - it's essentially a digital rolodex. Vendors table or present at one or more events each year, currently indicated in a dropdown list column that allows multiple selections. I know I can…
-
% Complete is Incorrect
In project settings I have dependencies enabled. This auto calculates % complete; however, the. percentage is incorrect. In my example I have 2 Parent rows, each with 5 tasks. Everything under Parent 1 is complete and everything under Parent 2 is not started. The % complete should be 50%; however it shows 43% complete. I…
-
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…
-
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…
-
Index-Match cross-sheet reference for a Contact List column
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulling it back, but it is not formatting the column as a "contact" - it looks like plain text (no contact "circle") This is my…
-
How can I append 2 columns together?
Hi! Just wondering how can I append 2 columns together? I have 4 columns: A, B, C, and D and each of the columns have 1, 2, 3, 4 values, respectively. What I would like to do is create 1 large column containing the values: A1 B1 B2 C1 C2 C3 D1 D2 D3 D4 If this isn't possible, this is what I'm trying to do. I have a 2…