-
IF OR formula for 3 conditions
Team, Struggling to get the below formula to work…any thoughts. (The cells contain numbers in text/numbers columns): =IF(OR([02/01/25]@row < [01/01/25]@row , [02/01/25]@row <> [01/01/25]@row , [02/01/25]@row > [01/01/25]@row ), "Down", "Same", "Up") Thanks
-
Why Isn't Assign Someone Automation Automatically Triggering
I have created a sheet to log all of the Change Orders coming into our PMO. The data in most of the columns are referencing a sheet that uses APIs to pull information from our client-facing system, but I had to create a separate sheet that is essentially a copy to support automations and some additional columns without…
-
Formula for Multiple same names count once AND single name counted as well
I used this formula from another community post which counts a person's name only once if it appears multiple times in the column. However, it does not count a person's name at all if the name only appears one time and I need it to. In the example below, how can I get it to count Doe, John as one AND Mouse, Mickey as one…
-
Inventory Grid
Hello, I have built a sheet to track stock/item quantities. I am wanting to show a live count of stock levels. I have used two separate columns for the item quantity so the people handling the stock can use a mobile device form to enter the data. I have also created a report to show the in and out sum of each item, but i…
-
Google Docs Add-on creating cover page with tab name
I've used the Google Docs add-on for over a year to create documents based on sheet data, and it's always worked great. Yesterday I created a new Google doc template to create documents from a sheet and the files that were created include a cover page with just the "tab" name at the top (so basically a blank page with the…
-
Issue with Searching a sheet with more than 10k rows
Hello, I am using the Smartsheet Search rows module in make : I am querying a sheet with 18k rows If i search for data in the first 10k rows it find is. if its after that, it doesnt find it. please help Kind Regards, Wesley.
-
All fields on the Smartsheet form is showing despite logic being applied to all.
Hello Everyone, So I built a form a couple of months back which was working fine with logic applied to it, but suddenly today when I opened the form, I saw all the fields are shown right from the start which should not be the case. Originally the form should only show the Full Name Email Department Request: On the basis of…
-
NLP Search Function?
Hi there, I'm working on a project to improve institutional knowledge for my project management team, and was hoping to make the team aware of the NLP search function within Smartsheet, which would greatly help in finding relevant archived lessons learned. The function however doesn't appear to be present at all, and the…
-
Copy of Response Interface versus Automation interface
Why in submit response the interface and output is more presentable rather than automation interface is it possible to enhance also automation emails interface and is there a way to customize the automation email body for presentable email notifications kindly refer to the image attached Email submit response submit copy…
-
Send an attachment as an attachment and not a link
It would be great to send attachments as attachments and not a link through the automated workflows.