-
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?
-
Why is a formula not triggering unless someone opens the sheet?
Hi there, I have 150 sheets that individuals use as time sheets. The sheet has rows for all the dates for a quarter. I have a "Current Month?" check box column in the sheet that checks the cell if the row date is in the current month. It uses this formula: =IF(MONTH(Date@row) = MONTH(TODAY()), 1) I have another check box…
-
COUNTIF with HAS formula
Hi, I'm trying to use a COUNTIF formula with a HAS criteria, but it doesn't seem to be working for me. Would someone mind taking a look? I'm trying to count the number of times "Apples" shows up in the multi-select column, Range A, while Range B also has "On Hold." Here's the formula: =COUNTIFS({Range A}, HAS({Range A},…
-
Multi Select HAS Formula
Hi I'm trying to get a sheet to count any projects where Finance Teams and / or Finance Systems are required to deliver a project at a particular status for a Portfolio dashboard metric. I'm currently using this formula but, it's not pulling the right info back - I'm getting a zero return when I'm expecting a number.…