-
Can you restrict columns to write only time/contact?
I know that we are able to restrict columns to write contacts only. However, for some reason even if I have the contacts listed, they still write down their email instead of selecting the contact drop down lists. Why is it not restricting properly? How would you restrict a certain column for the person to input time only…
-
COUNTIFS formula giving incorrect value
My Countifs formula is giving a different value than when I filter on my sheet which is the correct answer. I am trying to pull the number of team members who were hired before Jan 31st, Termed between Jan 1 and Jan 31, are current employees (no term date), who do not fall into the position code or term code in the…
-
Why can't I compute a simple division formula?
I am trying to divide one cell by another cell using the below to formulas. I am getting a #invalid operation. =COUNTIF(Complete1:Complete12, 1) + "" =(Complete14 / 12)
-
SumIF formula not pulling the full amount of values
Hello! I have two sheets, one that has General Ledger amounts for month end and the other sheet is a summary sheet that pulls in the total of the general ledger amounts for each specific GL. My formula on the summary sheet is referencing sheet one with the following formula… =SUMIF({Code}, [Budget Code]@row, {GL Balance})…
-
Seperate Name
Below is a formula I found here in the Community. While the first name worked, the last name didn't. Well, it did but the comma is appearing. I also noticed that if the hyphenated name is lenghty, it only returns the first part of the last name, the dash and first letter. I also have names that are pretty lenghty that…
-
Extract first 3 letters after the first space
Hello, I'm looking to extract the first 3 letters in the word that follows the first occurence of a space. Here are some examples: Budgeting Building Relationships Changing the Language Holding People Accountable For "Budgeting" it's fine to return nothing. For Changing the Langauge I would want to return Lan…so maybe I'm…
-
Can you use sum and min together
Hello, Im trying to get a min of 4 if PA points and SS points are both active then have 4 or the number that is either ss or pa add to the other columns, is that possible? Here's the formula I came up with but its not working. =IFERROR(IF(OR([Status Detail]@row = "Ready to return", [Status Detail]@row = "Transfer"), "N/A",…
-
Help with COUNTIFS Formula for Multi-Select Dropdowns in Cross-Sheet Reference
Hello Smartsheet Community, I am currently working on a formula that needs to reside in a metadata sheet and am facing a challenge with multi-select dropdown columns. Specifically, I need to count rows from another sheet based on the following criteria: RAID Type is "Risk" Impact Type contains the substring "Business"…
-
How can I get a new row to populate with the format and formulas of the row above it?
The rows will be children of a same group. I am trying to make a simple checkbook style sheet and I want users to be able to add rows and have the all the formulas and formatting iterate down. From the above screenshot, I want the yellow fields to be added and the formula that subtracts the amount paid (yellow cells) from…
-
Trying to copy rows & then mark them 'done'
I'm trying to do something that seems simple but is really frustrating me. I want to copy certain rows to another sheet and mark them 'done' afterward. I've got an automation that copies rows over to another sheet, then records a date & locks the row. I also want to have it change a value in another cell (mark it…