-
Multiplying the Values of My Ancestors
Hello, has anyone found a way to multiply the values of the Ancestors for a specific cell together? For example, I'm trying to get the total amount of 31445A113 required for the assembly A-341-10-1-0999. I was hoping to just use the Ancestors formula to multiply the quantity for A-341-10-1-0999 (x2) but the quantity for…
-
Formula Error multiple criteria
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
-
How to Tally Days with an Date Entries
I have a form set up for people to enter their CHECK-IN and CHECK-OUT dates. I'm looking for a way to have the dates tallied for all reservations received. So for row 1 - a "1" would enter under 7/21, 7/22, 7/23 and 7/24. And for row 2 - "1" would enter in 7/21, 7/22, 7/23. etc. to 7/26. Is there a way to do this so I…
-
Training Registration and Training Tracking
Think of this a little bit like a registrar. We, at New Mexico State University, conduct a year long paraprofessional certification program. *Participants register for the program. *Training consists of a one week introductory, in person, course, followed by six, live zoom training sessions, spread over a year. *The…
-
How do I limit the number of entries under the same company name
I have a list of companies that are allowed 2 complimentary registrations. I want a notification sent if a third registration is added that tell the company rep they need to pay for the third registration. I have a list of company names with the contact information. I then have the registration list with a form for…
-
Collecting the most recent submission
Hello, I have set up a sheet in which a form will submitted with 4 columns; a specific label (from a dropdown list), and then up to three barcodes. On the grid I also have a hidden created date column. I am then wanting to create a separate sheet that collates the most recent barcode for each column for label for the day.…
-
Please add a Wildcard Function
Smartsheet is missing the ability to use a wildcard (*) in it's functions. This is a valuable tool and would be incredibly helpful, please add this functionality.
-
Conditional Formatting
Hi all, and thanks in advance. I was trying to do a Conditional Format on this. I know how to do it in Excel, as I would use a formula, but I am having trouble with only the dropdown choices available. Okay, I want my CF to check if the 2 circled columns are the same. This instance does not show, however basically I am…
-
Intermittent Errors on Column Formula, Report always displaying errors
Why is my sheet intermittently displaying error messages & Report always displaying error messages. One minute the columns have data then randomly they all show up with the error messages? My report consistently ONLY displays error messages. I have a sheet performing calculations related to consumption of water based on a…
-
Formula to Pull In the Sheetname to A Cell?
Hi all. Is there a formula or a way to pull in the name of the open sheet, into a cell on that sheet? Ideally I was thinking something like =sheetname but that's not an available formula.