-
Automate checking a box if date column is less than 2 weeks?
I have a check box column (can be changed to symbol if needed), and Id like the box to check if the date in another column is less than 2 weeks from the current date. What would the formula be? Thank you!
-
If Formula with Dropdown conditions based on Dates
I'm looking for a formula that could be integrated into a drop down field based on a past date. I'm trying to have the "Status" column automatically flip to Off-Track if the date in the "Finish" column is now in the past and the "Status" column is not already in At Risk or Completed status. I'm able to use =IF(Finish1 <…
-
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…