-
Simple formula to show if two cells match- what am I doing wrong?
Hey everyone, I am having trouble with what I thought would be a simple formula: I have a sheet that is drawing information from two different sheets via cell linking and a SumIf formula: Total Order Cost, which is linked to one sheet and Invoice Total, which is summing all cells that match my primary column, which is…
-
Status Change if Column Checked
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below) Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from…
-
Auto format phone number
Good morning, I'd like to have our phone column (text) formatted so that when I input just the numbers (ex 7195555555) it would format the number as (719)555-5555. Help? Blessings, Loann
-
If/Or formula wit a Checkbox.
I need to color a ball yellow if the value in a column is between .05 and .15. If the value in the same column is greater than .15 OR a checkbox is selected, I need the ball to be red. Not sure how to accomplish this. Appreciate your help.
-
Checking Some Children Rows but Not All
Hi everyone, I'm somewhat new to Smartsheet and I'm still learning about formulas and functions. I have a parent row and 4 children row. If all 4 children rows are checked, that's great but it's most important that the last 3 are checked in order for the parent row to automatically be checked. I set up a function.…
-
Search Projects as Per RYG status
Hi, I looking for solution or moreover a formula to get a project name back as per RYG status. But i am getting problem, i have a same RYG for more then one projects. For example: i want a list of projects As RYG "RED", the selection has to show me 2 projects in retuen Project 1 Red Project 2 Green Project 3 Yellow Project…
-
Scientific Notation
Is there away to get smartsheet to recognize scientific notation in order to add, subtract, multiply, divide, etc.. Thanks
-
Total Sum By Month selected on Dropdown
I need to be able to select to view the total cost of children by a certain month. Currently, I have the dropdown values of all 12 months. I have the formula to the right of the dropdown calculating the total cost recorded for each child. But based on a different month, I want the value to change based on the date recorded…
-
Formula returning a blank cell
I have been trying to figure this out for hours with no luck. We've created a formula to automatically update our status column in our project plan sheets. We have specific parent rows that are designated as milestones. The milestone row status cells should update based on the status of the child rows. A milestone row is…