-
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…
-
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…
-
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.
-
Best way to cross-reference multiple sheets for repeated values only?
Hello all! Looking for some advice here. I have multiple sheets that track guests invited to events (5 right now, but it will continue to grow). I want to create a something that references them and lists only people that have attended more than one event and which events they have attended. So for example, let's say on…
-
range checking & flags
Hi, I'm trying to leverage a formula to check if the employee ID is listed on another sheet. Sheet 1 (sanity check): This is where I want the formula to live. On sheet 1, if the employee ID on the row is not listed anywhere on Sheet 2's Employee ID column (range), then turn the flag on. If the employee ID on the row is…