-
Nested formulas
Hi, I have 3 formulas and I was wandering if I can combine them into 1: =COUNTIF({Survey Date}, Label@row) =COUNTIFS({Survey Date}, Label@row, {Survey Grade}, ">=8") =Percentage@row / Count@row Thanks much!
-
Countifs... something off
Hi there! I am trying to do a COUNTIFS formula for a sheet where I am nesting three formulas into one for results. There are three different columns(ranges) I am using - doing the formula in sheet summary as well. Each of the three formulas works in themselves, but when I nest them together I receive Unparseable... Any…
-
Need Formula: "Is this person listed again in the next week?"
I'm trying to figure out how to build a formula with this logic. When a person is listed on a row with start and end dates, are they listed again for an upcoming event in the next week? Is it possible to create a formula that gives a yes/no answer. Or gives a count of how many times a person is listed in the next week? Or…
-
Synchronizing data from Microsoft excel into an existing worksheet in smartsheet
Hi everyone, i recently uploaded a file from excel and linked it to an existing worksheet in smart sheet. The file in excel is updated every week. Is there a way i can synchronize the file with smart sheet without having to upload the file again every week.
-
Pulling email from other sheet when corresponding business name is entered
I have a sheet with the name of a business and the corresponding contact emails for each business. In another sheet, I would like for the name of the contact to populate when the corresponding business is entered on the same row. here's what I've tried... =IF([Name of Business]@row = {Recall Business Contacts final Range…
-
Disappearing Formulas in Locked Column
I have a locked column with a formula used for a calculation. The formula is dragged all the way down. The formula keeps disappearing within blank cells. The activity log says it is changed by cell link. I keep dragging down the formulas and saving, but it just resets again. Any ideas?
-
Have a specific cell auto increment up as a new number is added
Per the example below, column "Total UG Footage Complete", I would like have the cell with "50" in it auto increment up when the box is highlighted and I added another 50 for it to show 100. Can that be done?
-
Form start timestamp
I've created a web form that will be heavily utilized. Managers are wanting to conduct a transactional analysis to see how long it takes the worker to complete. I'm looking for a way to capture the current time either when the form was accessed or find a shortcut to copy from the operating system and paste into the first…
-
Calculate new start time for whole schedule
Hi there! As an event organizer, I want to automatically update my schedule in smartsheet when a session takes longer than expected. Column 1: Start Time (HH:MM) Column 2: End Time (HH:MM) Column 3: duration in minutes Column 4: new start time (HH:MM) how can I arrange a formula so that once entering a new start time in…
-
COUNTIFS with NOT CONTAINS from a Referenced sheet with two columns selected
Hello! I've searched through a few community posts but cannot seem to find an answer to my formula I'm trying to calculate how many products we have in one column that are not "done" from another column that are both being referenced from the same sheet where: {product} = Product1, Product2 {status} = Done, Ready for…