-
Combine data from multiple columns, unless data is the same
Hello Smartsheet Community! We have (2) sets of columns of data that pull in data from (2) other sheets for Ship Dates, Tracking, Order Numbers, etc. Sometimes both sets of columns will be populated sometimes just one column will be populated. We are currently using the JOIN function to combine the data from a set of (2)…
-
How to prepopulate a form using the row as a reference?
Hello, I apologize for the simple question. I am a beginner with Smartsheet but I have not found the question answered in the help sheets. I would like to prepopulate a form answer using the row as reference. I can get the form to prepopulate but I have to enter the address manually in the formula each time. I have…
-
IF CONTAIN formula - Email Validation
I'm attempting what I'd consider a pretty basic IF CONTAINS formula, but I'm not getting the results I'm expecting. As an attempt to validate emails, I'm trying to use IF CONTAINS to turn on a flag when .com is not found in the email cell. "Your email" field contains email, which in input by the user via form. "NEEDS…
-
Smartsheet formula to only apply to Parent Tasks with specific criteria
Hello, I have been using Smartsheet for a few months but am definitely still considered a beginner. So far, I've gotten by fairly well thanks to this forum :) I am using the following formula which calculates the % of child tasks which are Complete, and it only applies to Parent tasks. This is great, but I only want it to…
-
=COUNT(DISTINCT(COLLECT
Hi, i am using the "DISTINCT" value in a formula which works great however is there a way to not count entries twice based on if its submitted as capital or lower case, for instance 'Fred' & 'fred' are counted as two unique names when in fact i only want it counted once? Cheers Shaun
-
Assign an "item" to a new owner and delete the same item from other "owners/cells"
how i can do it, assign an "item" to a new owner and delete the same item from other "owners/cells", in an automated way, or in anothers words, there two conditions: -assign "equip" column to "owner" column -delete the same "item" from other cells in the "item" column example> i really appreciate any help.
-
How do I subtract days from a date
I'm trying to build a production schedule spreadsheet. In one column I have the date the production item needs to be completed. In the next column I have the number of days (just a whole integer number) needed to complete. I would like to use a formula to determine the date production needs to begin. Simply (Date to be…
-
COUNTIFS with a Date Range
Hello there, I am needing help with a formula, i am trying to count the number of faults that happen per week. I have the below so far but it is coming up #UNPARSEABLE =COUNTIFS([Faults]:[Faults], [Week Starting]@row >= [Week Ending]2 <=,[Week Starting]@row >= [Week Ending]2<=)
-
COUNTIFS using MultiSelect as criterion
I have a sheet that is tracking all of the tasks users need to do in a year. They enter the recurrence of the task as Daily, Weekly, and Monthly. They also enter the Start Date and End Date (ex. 3/15/2023). I then create rows for each month the task is running. So 3/1/2023 - 5/31/2023 would have three rows (March, April,…
-
Using an OR in COLLECT
Hello - I'm trying to use an OR operator in the criteria of a collect function. This is currently returning an #INCORRECT ARGUMENT SET: =IFERROR(INDEX(COLLECT({WAP Deposit Number}, {WAP Date}, Date147, {WAP Type}, OR("CHECK", "CREDIT"), 1), "")) I'm trying to return the a deposit number {WAP Deposit Number} if the Date…