-
Having a tough time with time calculations
Hello Everyone, I have been referencing the Time calculation post: How do I create time of day columns? - Smartsheet.com For some reason the very last formula listed below returns all the minutes as "00" instead of the actual minutes. I am basically copying the formulas listed in the above link except I never have to worry…
-
Formulas to Add Meeting Date and then Corresponding Due Dates?
My company has a regular meeting with a client, with required notes due 3 days later, for several years. I am looking for formulas that will help me do this efficiently, but I haven't found answers with searches. 1) Is there a formula/function to find the last Monday in a month? This info would go on the monthly meeting…
-
Count Multi-Select with conditions
I have a ongoing sheet with Clients (Single Select Dropdown) and Tests (Multi-Select Dropdown). I'd like to know the ongoing total of Tests selected per Client. I can't seem to figure out if this is a combination of Countifs and CountM or if I should use Collect, Has, Contains. I know this is simple I just can't put it…
-
@Column Reference
I have a formula that I would love to make into a column formula but am unable to because I reference a cell (a helper cell I have in the first cell of the column that is the same as the column name). Without being able to use [column name]1 in a column formula I am unable to have it be a formula that can be easily copied…
-
How do I return text from text string with the space as a delimiter?
Hello, I am trying to extract each word, or a set of words from a text string that has spaces in between. Example: AW (Ground) AIRTOP Tropical Day Cart 500mL How do I just return each word by itself in different columns? Thank you!
-
How do I write my SUMIF formula so that it automatically sums numbers in its own column?
All -- I am putting together a SUMIF function for Column Beta that adds together only those column entries whose Column Alpha have a specific value. This gets me: =SUMIF(Alpha5:Alpha56,"Value",Beta5:Beta56) According to the Help & Learning article on SUMIF, the "Beta5:Beta56" part of the formula is called the "sum range."…
-
Duplicate Helper column with filter
Hi! I'm trying to build a formula where I search for duplicates within one column (Job Numbers) but only if "Invoice" has been selected in another column (Deliverable Type). I was able to get a formula to search for duplicates working but it is searching all the deliverable types, but I just need to know if there is more…
-
How could we convert the day to year?
i have tried to number of days divide by year, seems not working
-
How to use If and and?
I have 3 columns A, B, C I need to write a formula that will return Column C based on the values of Column A and Column B. If Column B=3 AND Column A is between 3.5 & 4.4 then return 4 If Column B=2 AND Column A is between 3 & 3.4 then return 3 If Column B=2 AND Column A is between 3.5 & 4.4 then return 3 I am able to…
-
Countifs Formula Referencing Another Sheet
I could use some help with a formula that references another sheet. The sheet I want to reference is titled: Certified Roster Status The sheet has a number of columns. But, there are two columns for which I want to use the criteria for the count. I’d like to get a total count from the column called Status when the word…
