-
How can I extract the date/time stamp from the Cell information to display as new column??
I do realize I can create an automation that flags a date stamp, but considering the sheet is over a year old and has a lot of data already. How can I make this information useable that is found in the cell history?
-
#INVALID DATA TYPE when counting column without a value
Hi guys, im trying to use CountIFs to count all projects that have a completion date by month. Not all projects are complete so there that are those that do not have an end date has the error #invalid data type". I tried using this formula, but didn't work. Could I have assistance fixing the formula? If there is an invalid…
-
Need help with cross sheet SUMIFS syntax
I have one sheet that is a master inventory sheet, and another with a bunch of formulas pulling data so I can build a report. I have been trying to specifically set up a formula that sums up all cells in the "Stock" column, only if it matches a specific keyword in the "Location" column. I have cross sheet references set up…
-
Count IF Question
Hello all, just me again with another Count IF question!!! I was curious if anyone could assist with a question of mine. I am using 2 Sheets. On Sheet A I have Audience Names that I am trying to match back to another sheet and see how many different campaigns are tied to the Audiences. I currently am using a count if…
-
Provide list of managed references while editing / creating a formula
When writing a formula where I need to use cross sheet references, I would love to have a list of the already created references on my sheet be available when I select "Reference Another Sheet". It could just be access to the already existent "manage references" list or could be divided based on the sheet that is being…
-
Creating a Formula where there is multiple selections needed.
Good Morning Smartsheet Community. I have been struggling with these formulas for a few weeks now and decided to finally reach out for some help. I am trying to make 2 formulas but there is a part of the formula where I need to reference 2 options in the same drop down. I think I am tripping myself up when it is having to…
-
MAX COLLECT across a range
I am a bit stumped and looking for a little help. I have a forecast sheet with a form where the user has to submit their monthly forecasts for the quarters across five subject areas. I have a column for each quarter and each subject area, 20 columns is my range, Forecast worksheet: Quarters For example purposes please…
-
If(Contains) issue
I am trying to look at a column on one sheet and if it contains a certain value or multiple of the values that I am searching for, return a sum of value(s) from one or more specific cells that are contained in a separate sheet, otherwise return as 0 or as if nothing has happened. This is the formula I have come up with but…
-
extract city & state from a city, state, zip cell
I want to extract the city & state from a cell that has the city, state and zip code. The zip code may not always be 5 digits (either 90210 or 90210-1234) and the City and State may not always have a comma separating them. A formula that can extract any text left of a numeric value is what would solve this, but I cannot…
-
Automatic Predecessor Adjustment
Hey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with the fabrication packages released from the Eng Dept. Sometimes the schedule needs to…