-
JOIN Muliple values dropdown menu
Hi, I have a simple JOIN formula to combine the cells on the right into a muli value dropdown menu column. However, for some reason, it will only show unique value and sometimes it wouldn't show it in order. Column "Join Formula" is a simple text/number column, with the same formula as "Join formula w/ muli dropdown". It…
-
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…
-
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…
-
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…
-
I want to count items within current month without needing to change the month manually
I need to report on the number of items that appear in the current month to date. Is there a formula that can be applied without necessitating manual entry of changing the month manually?