-
Using COUNTIFS with OR function spread across multiple ranges
Hello, I am trying to build a COUNTIF function that will count all cells which meet criteria 1 and either criteria 2 or 3, which are found in different ranges. Example: In Sheet1, I have the following columns: shape, color1, and color2. In Sheet 2, I would like to create a function which counts all observations in Sheet1…
-
Comparing values from different sheets in excel
Hi, I've been searching for an answer to my question almost the entire day but can't seem to get it right, so hopefully Smartsheet can be my savior here 🙏 So I have Sheet1 in Excel with two columns, both with texts in it. Each row has a different word in it: column A, row 1=text1, column B, row 1=bananas, column A, row 2=…
-
Is there a way to pull info from a form submission and enter it into another form?
I have a form I am currently running, that whenever answered, needs to be reviewed by another person. I am currently using the approval workflow, and putting it in the email with a link to a form that the reviewer needs to fill out. Is it possible to take the info given from the previous form and put it in the next one so…
-
Data Over Time Report/Dashboard
Hello, What steps should I take in creating a dashboard that includes a graph displaying data over time? I would love to be able to click on each data point and a pop up of that data point displays information during that time period. Here is an example of something I would like to create in Smartsheets
-
How can I track when a ticket is past its number of SLA days??
Hello, thank you in advance with helping with this question! Please see below: Situation: My team uses a Smartsheet intake form to take work requests from other teams. This populates into a sheet with the needed information to move tickets to different status' (ex: New Request, Active, Backlog, Triage Required). All of…
-
Move a row form one sheet to another in a different workspace
Hi I am trying to move a row from one sheet to another in a different workspace. I am the owner of the original sheet and I am the owner of the destination sheet and workspace. Is this possible as nothing comes up when o search for the sheet I want to move to.
-
How to summarize data from multiple sheets without manually linking each cell?
Hello, I'm working on a project with KPIs that will be entered into ~50 individual sheets. I want to be able to roll-up these KPIs into one summary view, but am running into trouble when I pull them into a report because I can't perform calculations in a report. One KPI is Overtime %, so I can't just take the average of…
-
How do I change when my Sheet starts the next workday?
I have a formula in Sheet Summary that counts workdays remaining until launch. It works except that the count doesn't go down each day until 10 AM. If anyone looks at it before 10 AM, it shows an extra day. I can't figure out why it updates at 10 AM, so I don't know how to fix it. Ideally, it would change at midnight.
-
Document the value of function / calculated field every day
Hi all, I have 2 sheets: 1) working sheet where all tickets are logged + their status is maintained 2) calculation sheet with fields showing e.g. number of open / closed tickets and so on (calculated by formulas which refer to the working sheet 1). These values are used for dashboards and so on. I wish to automatically…
-
Can I access/download spreadsheets I previously made without paying for the upgrade?
I no longer have the need to use the Smartsheet service but I would like to e able to refer back to the reports, sheets, etc. that I made while using the upgraded version. Is that not possible?
