-
Counting the number of lines by 'Current user'?
Hi, I'm looking for a way to count the occurrences of lines with 'Current users' in a grid/report. I've got a dashboard that displays various lines submitted by multiple users, but uses the current user filter on the report so that the person logged in will only see lines created by them. What id like to do is create a…
-
Is it possible to add all values that occur within the same date range
See image for what I'm trying to achieve. Essentially I'd like to know if it's possible to either display values in Gantt view or if its possible if I have a value in a column (Est Hours per Phase) if I'm able to sum the total hours that occur in a given week so I understand the total effort required for that week. See the…
-
I would like to set a date "Completed" based on a status of " Completed"
I have a status column and one of my choices you can pick is "Completed" . When you pick "Completed" I want to set the date in the next column to the date that "Complete" was selected and I don't want the date to change once it is set unless the status changes from "Complete"
-
Function to Print a Date and Keep it in Column Until the Function is Satisfied Again
Hi All, I'm working on a database sheet at present to track material deliveries in a lab. One piece of functionality that I require is the ability to hold a reorder date in a column as a notification to people if material in-house is due to expire. Below is how my sheet works: As stock becomes low, a column called "Low…
-
Formula not working as in instructions.
I am trying to follow the instructions on the SUMIF formula page. I created a sheet with only the "Sold Date" and the "Transaction Total" columns, entered some data, and I copied the formula "=SUMIF([Sold Date]1:[Sold Date]3, MONTH(@cell) = 2, [Transaction Total]1:[Transaction Total]3)" and pasted into a Summary Sheet…
-
COUNTIF Checkbox Help!
Help!!! I'm trying to create a formula that counts a row if a column "A" value =X AND column B check box is checked. I have tried the following and it does not work. Any suggestions? =COUNTIF(Status:Status, OR(@cell = "Partially Invoiced", @cell = "Cancelled", @cell = "Contract Requested", @cell = "Contract with Client for…
-
Date line graph--is this possible?
Hello, I'm trying to figure out how to create something like the image attached. Each point is a project and the dates correspond to the approval of each project. Each dot would have a project name label on it (removed here for privacy). They are horizontally divided by market (each color is a market and label also removed…
-
Do formulas not transfer over to reports?
Hi everyone, I have a formula in my sheet that is not showing up on my report. It's a simple formula; how many days late something is, and I really need that info displayed in the report. Ideas, tips or tricks? Thanks! Ashley
-
Copy sheets and references
Hi Everyone! Let's say we have one folder [A] with 3 sheets that have references. If I want to make a copy of this folder (Folder B), I can make save as new and save it...By default, it will keep all the references relative to the newly created sheets. what if I added a new sheet to folder A and I included some references,…
-
Daily report not updating
Hello Smartsheet community, We are currently facing an issue with our daily reports intended to check which deliverables are late. We have a structure with several dashboard for project follow-up, in which we have a deliverable sheet with due dates. Inside of it, we have a formula comparing the TODAY and the due date to…