-
Calculating % with a minimum value
I'm looking for a formula that calculates the percentage of two columns, but shows a minimum percentage of 50% if the calculation is less than that. Is this possible to do in one column, or do I need to have one column with the percentage, and the next with an IF function? My knowledge of functions is limited so thanks inโฆ
-
Column Formula to mimic HLOOKUP?
Hi, Gurus! I have a sheet that calculates 2 values based on whether the calculated columns contain an "X" in Row 2: #Actual formula is: =SUMIF([Week 1]$2:[Week 300]$2, "X", [Week 1]@row:[Week 300]@row) [has "X"] #Forecast formula is: =SUMIF($[Week 1]$2:$[Week 300]$2, "", $[Week 1]@row:$[Week 300]@row) [no "X"] I need toโฆ
-
Survey Results- Word needs to be changed to number to quantify
Good morning, I am currently working on a survey where the questions used words instead of numbers. I need to change the results from the words to a numerical value. Example: Excellent= 5, Good=4, Fair= 3, Poor= 2, Very Poor = 1 Thank you!
-
Today minus a date field
What am I doing wrong? =Today() - [Column 5]@row Column 5 is a date field. This is giving me an #DATE EXPECTED error
-
How to Flag First Event Date by Location
I've been researching this for a while and haven't been successful yet, hopeful the community can provide some solutions. I have a sheet that tracks all events across multiple clients. Each client has multiple locations and each location can have multiple events. I need to be able to flag the first event date for eachโฆ
-
subtract a number form another sheet
I need to subtract a number from another sheet - cant seem to reference the other sheet please help
-
Counting unique values in Column B against unique values in Column A
I want a formula that will enable me to count how many unique Groups per Account Manager, eg AM 2 has entered 4 groups, but only 2 are unique. I've used a COUNT formula to see how many times each Account Manager appears in Column A, and a COUNT(DISTINCT) formula to count the unique Groups in Column B, but how do I do thisโฆ
-
IF statement to update "Health" column base on "State" and "End Date"
Hi everyone, I'm trying to create a formula that: If state is not complete and end date is in the past, then health column will show โฐ State - Drop Down menu: Complete, In Progress, At Risk, Blocked, Not Start Thank you in advance!
-
Pull personal tasks into roll up sheet
Hi everyone! I'm trying to set up a way to pull selected items from personal task sheet into roll up sheet. What difficult for me is: for the personal tasks, I don't want to pull all tasks. There are tasks that I want to keep it private, and tasks that I want to show in the roll up sheet. Can someone help me with this,โฆ
-
Automated way to move "Comments" (Conversations in Smartsheet) from column to Conversations
Hi, I have a team maintaining an Action Tracker. All are relatively new to Smartsheet from Excel and most are at a higher pay grade than me. As such, they asked for a "Comments" column in the Action Item grid to track DAILY actions and updates. As you can imagine the row sizes are quickly becoming unmanageable. Is thereโฆ