-
Setting chart colors before all options have values.
Hi, I am trying to show a series of data statuses. Currently, all of the status are "Open" (work has not started). I have all of the options selected as data for the chart, but SmartSheet does not allow me to assign a color until the values are greater than "0". Is there any way I can preset these colors so that when the…
-
COUNTIFS Formula
I'm having a hard time figuring out the formula to use if I have a column of dates and I want to count how many cells fall between a date range. I have tried the following formula and the results came back with 0, however I know there there are 7 cells in the column that fall under the date range. =COUNTIFS(Date2:Date73,…
-
Non Human Resources
Hello Everyone, Can Smartsheets manage not human resources? In my case I am more interested in managing machines that people/ Cheers Kurt
-
Nested IF, AND, OR/AND
Hi all, New user here. I have different monthly metrics to comply, some are greater than or lower than a value or percentage (i.e. Open tickets beyond due date is LOWER than 10%, Survey results are higher than 70%, Safety observations over 30). I created a column [MEASUREMENT] stating "Higher than" or "Lower than", a…
-
Recurring Weekly Tasks
Hello, I've seen a couple of entries related to this, yet I think my question is simpler. Is there a click somewhere that would automatically populate a weekly task? For example: "Review Meeting", from 3/31/18 to 7/31/18, must occur weekly. Is there an option for this, similar to my Google Calendar? Or do I need to copy…
-
I can't figure out how to use the OR function in a Countifs formula
Hello, I have been creating metrics on my data in smartsheet using the different formulas. I have figured many out (with a lot of head banging and sleepless nights), but cannot figure out how to use the OR function. works: =COUNTIFS({Week}, =$[Date Range]$3, {Month}, $[Date Range]$5, {Year}, $[Date Range]$8, {task status},…
-
SUMIFS in a Dashboard or Report that references another sheet
Hello! I'm looking to utilize a Dashboard or Report and can't, for the life of me, figure out the best way to do this. I need to give a summary of units sold to a customer, per product type, per year. See attached screenshot. Questions or need additional information, just let me know. Thanks, Matt
-
Setting up Alerts
We are running a number of different projects on a sheet that have a: 1) - Delivery Deadline (which is specified by the client), 2) - Delivery Date (which is set by dependencies on our Production Schedule) When Production is running late, the Delivery Date can end up later than the deadline. How can we set up an alert to…
-
Is there a way to auto sort data on a sheet (cannot use report) to show the Largest to Smallest?
Hello, I am creating dashboards using metrics and am trying to figure out a way to only show the top 15 of specific data. Sheet details: I have one column that contains 298 different locations and the next column is the # of issues at that location for last week. I have the formulas figured out to pull in the metrics…
-
How can I include an attachment shared to the sheet in requests for approval?
I am using a sheet to manage a client contract approval process. I am imagining attaching the draft contract to the sheet itself or to a single row towards the top of the sheet. I have several approvers listed below in separate rows and need to send out requests for approval with the draft contract attached. Is there any…