-
Count if Production is anywhere in the cell.
PDCA range 2 is a drop down list. It is counting it if Production is the ONLY thing selected. If there are multiple things selected, it wont find it in the list and count it. Formula =COUNTIFS({PDCA Range 2}, "Production", {PDCA Range 1}, FIND("OK 3", @cell) = 0)
-
Unlicensed unable to receive verification email
I have an unlicensed user who inputs data into my smartsheet. He is supposed to received a confirmation email once his form submission has gone through with a copy of the data that he entered for his records. He is one of many employees who uses this form but is the only one unable to get the email. I have checked his…
-
Drop down values in grid view not showing in report
Hi I've build a report from a grid sheet. All values shows, except in the columns where the column type is a dropdown. Is this correct? Grid info: Report info: If I change the column type to text, it shows in the report. But I would like to limit options in the report to a dropdown list. Please help?
-
If Formula with a Dropdown List
I have a column titled Status that includes the following drop down selections: Not Started, In Progress, On Hold and Complete. I want to write a formula that based on the drop down selected, another row would populate the following automatically: Not Started = 0%, In Progress = 50%, Completed = 100% and On Hold = ON HOLD.…
-
When will we be able to link QR codes to a particular line within a spreadsheet?
We have an existing sheet at my company (that has already been implemented) which contains all of the work orders we are working on. Multiple departments work from this same sheet during the day. I'd like to apply QR codes to the documents we generate within the spreadsheet (e.g. hard copy work orders, production reports…
-
Returning text from another cell based on a certain variable.
Cell - Brian_Borders@na.honda.com want to return in cell Brian_Borders...using the @ sign for a stopping point.
-
Need to count "time allotment" If certain statements are True
Hello, I am trying to count the "time allotment" using the below restrictions. The below formula counts how many meetings each person has, I am trying to add another one to count how many hours of meetings they are in. Working Formula for how many meetings: =COUNTIFS({Editor}, HAS(@cell, Metric@row), {Type}, "Meeting",…
-
SUMIF & WEEKNUMBER
Hello! I'm trying to create a separate metrics sheet which shows total refund $ processed by week. Attaching a screenshot of example columns. I know it involves SUMIF & WEEKNUMBER (already working in the 2021 Week Number column) but I'm having trouble putting the formula together. Any help would be much appreciated! Thank…
-
Formula for several "If/Then" support
Hello Community! I have tried googling this for excel and I'm just not getting my formula to calculate what I want/need. I've created formula for equating a number range to a letter, but I can’t figure out how to get the letter cell to not populate if nothing is entered for a numerical value (left blank). I don't want to…
-
Looking for suggestions
Hello all! I'm looking for suggestions, I have just created a sheet to keep track of our employee absences. What we need is something to count the SICK calls per colleague. Our plan is when colleagues reaches 20 sick calls, notifications are sent to management for follow up. At which point we conduct a meeting with such…