-
Adding 1 more condition to AVG () with Collect() formula
I have successfully used the below to average the aging for help tickets that were reported between 2 dates. I need to add one more condition, so that it only provides the average if the severity of that ticket is Urgent or High (using @row). I cannot figure out where/how to add this third condition. =AVG(COLLECT({Closed…
-
Is there a way to create a search box?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
-
Auto- fill information from another smartsheet
How can I make my smartsheet pull columns of information from another sheet? The data I want to have duplicated is entered first on a vendor intake sheet, the two columns I want to 'link' or duplicate are a unique name and contract number (in separate columns) and I want to have them pre-populate on a contract deliverables…
-
Formula for days of week a ticket was submitted
Hello, I am looking for a formula to put the days of the week a form was submitted. i.e. monday, Tuesday, Wednesday, etc. I already have a created date column which i need to stay as it is but want another column for the specific day that it was.
-
looking for help with a formula that uses one "text", and one "match" or "has" condition.
the closest I have gotten to getting some results is using: =IF(AND(CONTAINS("Q8", {Expenditure Report Collection Range1}), HAS({Expenditure Report Collection Range 2}, [Primary Column]@row)), "ok","missing") maybe I don't understand order of operations but it's giving me a "ok" on a cell that should be missing. I need to…
-
Formulas in Forms
When putting a formula into a hidden line in a form, every time the form is submitted a ' is automatically inputted in front of the formula. This obviously prevents the formula from acting like a formula, but instead just shows the text. This form allows folks to scan a QR code to get the part code (shown as TESTITEM in…
-
Count unique values from a separate sheet
Hello, SmartSheet newbie here with my first question for the community. We were able to build a working formula to count unique tickets in original sheet =COUNT(DISTINCT([Ticket #]:[Ticket #])) I then took the above formula to my metrics sheet and changed to reference another sheet value and the formula no longer worked…
-
How to automatically generate a Date that's three weeks later than a given Date in another column?
I have a column named "Creation Date" (Date Type) and another one named "Response Due Date" (Date Type). The "Creation Date" is automatically recorded whenever a new row is added. How do i automatically set a date 3 weeks later in "Response Due Date" column. KEEP IN MIND PLEASE, that i already have 100 rows with manually…
-
Is there a formula that compares 2 text cells and captures the difference?
Hello! For a project I'm working on, I need to be able to capture changes made to certain cells (and what specific changes were made). Capturing when a change is made is not the issue, because I know I can figure something out with the auto-rules. But what I'm looking for is a way to compare the changes made with the…
-
MAXIF, MINIF, AVGIF Formula Capability
It would help to have the IFS functionality and combined statistical functionality MAXIF, MINIF, AVGIF, MAXIFS, MINIFS, AVGIFS similar to the current SUMIF and COUNTIF. IFS can shorten multiple nested IF statements and easier to formulate, read and understand when referencing multiple conditions. The combined statistical…