Formulas
Discussion List
- 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 ca…
- 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' ar…
- 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" …
- 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 numbe…
- 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], [We…
- 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/…
- 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…
- Hi All I am trying to set up a status message based on a few variables. I can get them to work indidually, but when I bring them all together I get an InvalidData error. The parameters are If FWA Requ…
- Hey there, If anyone can help. I have set up two calculation sheets. The first is a Bill of Materials with the second being a variations sheet where I can combine various options from the BOM sheet. E…
- I feel like I've been going crazy. Trying to get a count of how many [Primary Column]45 appear when the other ranges have the listed criteria. All ranges are multi-select drop downs. Keep getting 0, w…