-
Date Range formula format
I'm trying to figure out a way to get the number of rows that have a date within a certain range. An example would be if I have a column with dates ranging from January 1 2020 to August 1 2020, how many of those dates fall in the month of January? Is this possible?
-
Test case Smartsheets
We're going into UAT soon. I've chosen Smartsheets to put all the test cases the testers need to run. Some things I'm wondering about - hopefully all of you ppl smarter then me can help: 1. I imagine that I will need multiple sheets right? Each tester will run the same end-to-end set of tests and record pass/fail/defects.…
-
Triggering a Microsoft Flow when a column is updated
Hi all, I have a smartsheet that my operations team manages. It tracks all orders that we receive through our defined shipping process. Each order is a new row and there are multiple columns. One of them is the "Estimated Shipping Date" which someone from our team will fill out. I want to create a Microsoft Flow that…
-
Gantt chart that overlays multiple projects
We are trying to see if there is a way to view a Gantt chart that overlays projects that are in multiple sheets so that we can make sure our department is not spreading itself too thin/which projects have overlapping timelines. Is there a way to accomplish this?
-
Formula to return the logged in user
Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODAY(), "")can we have something like =IF(Closed1 = 1, Logged user, "") I know that there…
-
Is it possible to have a column in a sheet serve as a reference to multiple other sheets?
Here is my scenario: I am redesigning some of my template sets and dashboards but leaving the originals up and running at the same time. I created a sandbox environment (workspace) to do this in. Some of the new sheets use the same data and formulas. Copy and pasting the formulas sometimes required me to recreate the…
-
Data Uploader Filtering
Hi All, Just a quick question regards the filtering in Data Uploader. I'd like to look at everything incoming from the report I pull for the last 30 days. Having already mapped the columns, I'm just wondering what would the correct formula criteria be. Incoming equals TODAY()-30 - or something similar? Screenshot attached.…
-
vlookup of image
Hi, Im Senando Benig Jr, Just Sen for short, Im in manila Philippines, My company start smartsheet from scratch and im the one assigned to develop an application. I explore smartsheet for more than 1 year and i think im in advance now. My concern is , is there anyway to vlookup and image? because when i try to vlookup it…
-
Need help with using a COUNTIFS with OR
Hi, I'm trying to create a nested formula used in a ticketing system that will total up active status (Open or In Progress) compared to location. Ticket Active Status for Location = Location <and> Status [Open <or> In Progress] My Status column is using RYG balls, so "Red"=Open and "Yellow"=In Progress. I keep getting…
-
Form Submission
If I create a form in smartsheet and someone were to complete the form, can I make it so that multiple people can be notified about the form submission and have access to the information submitted? If so, how do I do that? Can this be done automatically without me having to check daily and send notification via email…
