-
Contact Cells that match
Morning Pulling my hair out! I have two fields, lets call them Manager 1 and Manager 2. Both are vlookups from a central approval names sheet. Works fine and no problems. I have a situation, because both fields are used in an approval flow, where I want the approval to only go to Manager 2 if that person is the same as…
-
Automatic date update in a cell when another cell's value changes (as calculated by a formula)
Hello I would like to have a field set up that updates the date every time the 'status' changes in another column. Is this possible? For example, when a new line item is added and the status column changes to 'on hold' I would like the date the status changed to show in another column. This date will stay the date since…
-
How to Return Many Values to Track Status Changes
We are trying to track the dates that tickets change from status to status. Using workflow, I created a new line added for each status change. But now need to return the dates on each of those lines entered. Below are screen shots of the two sheets I am trying to do this. Tried Vlookup, Match and Index but cant get them to…
-
Using LEFT Function with Countif
Hello, I receive a data from other parties that is formatted inconsistently. The column of interest is labeled Target Months and ranges from things like "36 Mo.", "12 mo" and "1Mo" etc. I am only interested in the number since I know it is referring to months. Using the LEFT function I can strip out the 36 and 12, however…
-
Interactive Dashboard
Hey all, Currently our organization has 56 Primary Care clinics in the DFW area. We are trying to create a central location where all the information associated with the clinic can be stored and updated. Examples are who is the Regional manager, how many physicians are at the office etc. I made a spreadsheet in Grid view…
-
Help automate the field update in formula so that my summary is always showing the most recent data
I am currently doing some simple data entry in Smartsheet for my company. I am fairly new to Smartsheet and I am still working on my skills in Excel. For one of my sheet summaries, I am using the formula =SUMIF(Date:Date, ="07/14/20", [COLUMN NAME]:[COLUMN NAME]) to sum the data in [COLUMN NAME] based on the current date.…
-
Average Collect Formula Not Calculating Correctly.
Hello, I am looking to determine the average time based based on start/ completion dates, location and the frequency in which the activity occurs. However, it does not seem to be calculating based on my criteria. Could anyone help me determine why the average is not calculating based on my criteria?…
-
If nesting... in a true/false - FOUND IT! Remove the 0 in the nesting
I can't figure out why combing these statements isn't working. This works: =IF(AND(CONTAINS("Director", [Approvals Needed]@row), CONTAINS("Lead or Supervisor", [Approvals Needed]@row), CONTAINS("Manager", [Approvals Needed]@row), [Lead or Supervisor Approval]@row = "Approved", [Manager Approval]@row = "Approved"), 1, 0)…
-
Need help refining a formula where my outcome keeps coming out to 0
For one of my formulas, I am using three columns; a date column (Week Begin) , name column, and number column (total inbound). I am trying to sum certain values in the total inbound column based on the name associated with the data and date range (one week). I am using the formula: =SUMIFS([Total Inbound]:[Total Inbound],…
-
Last 7 days
I am trying to create a formula that will pull data from two columns in the sheet as follows: Sheet columns include intakes by location and a date entered column. I want to create a roll up at the top to show intakes by location in the last 7 days that automatically updates. Here is what I have:…
