-
Enter number in cell based on which checkbox is checked
I'm new at this so patience is appreciated. I want to fill a cell with 2%, 4% or 6% based on one, two or three checkboxes. If checkbox Credit 1 Complete is checked, Credit Obtained = 2%; Credit 2 complete, Credit Obtained =4%; and Credit 3 complete checked, credit obtained =6%. Credit Obtained cannot be 6% without the…
-
I'm trying to calculate the number of instances where only two items appear in a cell.
I'm trying to calculate the number of instances where only two items (the words content and functionality) appear in a cell. My current formula is not pulling the correct count. Any suggestions? P.S. I'm a formula rookie :) =COUNTIFS({Sub Type Update}, "Functionality", AND "Content", {PhaseForecast}, OR(CONTAINS("Planned",…
-
Count if text in cell contains specific item
I'm trying to count how many times a specific text string appears in a cell but tie it to an event name that appears multiple times. I've tried countifs with a contain. I tried reversing it and starting with an IF(Contains) and can't get anything to return what I need. In plain English, count If Trip Name = 24-03 AND Type…
-
SmartSheet Form and Auto-Number Field as an option
Is it possible to create a SmartSheet Form, and utilize the Auto-Number Field (created already in a sheet) as an option to take advantage of the conditional logic? Example: 1) Open form 2) Enter Auto-number 12345 (from existing sheet entries) 3) Once selected, conditional log would display next field (if already filled…
-
Cells change counter
Hi, community. I have a question about how can I count the cells changes. For example, we have a column called Status, and we have two status: developing and QA. I want to know how can I count how many times a cell change to developing. I tried with automatizations but I didn't have success. I hope someone could help me…
-
Formula for column sum this month
Hello! I want to make a sheet summary formula to calculate the sum from a single column just within the current month. I've attached a screenshot of the columns I'm working with. Thank you very much in advance!
-
Finding the most recent entry
I have tried finding the answer, but for some reason I can't seem to get the formula(s) to work for me. I have a sheet where other users update our fleet information using a form. I am trying to figure out how to find most recent date for each of our uniquely numbered ships. I keep seeing the formula Max(Collect, but I…
-
IF with Summary Sheet Information
=IF(Jan2 >= 1, [Baseline = 1-250 Devices Shipped]#, IF(Jan2 <= 250, },[Baseline = 1-250 Devices Shipped]#), IF(Jan2 >= 251, [Tier 1 = 251-500 Devices Shipped]#, IF(Jan2 <= 500, [Tier 1 = 251-500 Devices Shipped]#), IF(Jan2 >= 501, [Tier 2 = 501-1,000 Devices Shipped]#, IF(Jan2 <= 1000, [Tier 2 = 501-1,000 Devices…
-
Why does the formula work on the cells i originally used it for, and not the new cells?
So, I've had this sheet working since last summer. Basically it's an inventory and project management tracker for fiber network construction. Tracks the units used in the field, tallies them up, categorized by date, and does the math to show cost. The formula I use works just fine on nearly everything, it's a pretty simple…
-
I need dates formula and automation help please!
please help me determine the following: I need a formula to automate notifications on the date when we need to be notified based on the criteria below send notification 90 days before written notification has to be sent if the notification has to be sent 30 days before the term end, 105 days if notification has to be sent…