-
AverageIf Dropdown (Multi-Select) cell contains an attribute/value
Hi Smartsheet Community, thanks in advance for all your help. I've been able to learn so much from the help you provide to others. I have two sheets I am working with for this experiment: A master project list, with unique projects aligned to an objective and the option for different key result attributes (Drop down…
-
Want to auto remember the last time value from other cell
I have one case，want to mark the origin value，for example: How can I do this?
-
OR in SUMIF function
Hello, I am trying to use OR in SUMIF function as below but get invalid operation error: =SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]83) + SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]84)
-
How to count incomplete tasks using % Complete?
Hi, I've got a project I've imported from MSProject, and my smartsheet has a % complete column. I'm trying to use COUNTIF to identify the number of tasks that are unstarted, those that are complete, and those that are in progress using that % Complete. I can get the first two to work, but I'm having trouble with the…
-
Formula to clear in certain fields of a row
I have a smartsheet for a workflow. If at some point there is a change order, then the workflow needs to start back at the beginning and most of the populated cells need to be cleared out. Is there a formula to make this automatically happen?
-
End of Month Function
Good afternoon all, I'm trying to figure out how to apply the =EOMONTH(A1,0) from excel into a smartsheet. Any guidance on this would be most appreciated! Thanks!
-
How do I create a formula to capture the total number of inquiries by group name?
I am trying to create a formula to capture the total number of inquiries by plan group name? I can use the formula =COUNTIFS({National Alliance Operation Inquiries Range 2}, "GROUP NAME", however, I have over 200 groups to choose from. I am not sure how I can capture them without creating a formula for each plan group name.
-
Need to create a "shift" column from a time column
I have a column with the time (hh:mm) an interaction took place. I have another (currently blank) column for shift that I need to populate from the time. The "shift" during which an interaction took place would be: 7Am-12:59PM as Day, 1-8:59PM as afternoon and 9PM-6:59AM as night. I'm not sure where to start. How do I…
-
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…
-
Dynamics metrics across new sheets
Goal: create metrics for a dashboard that automatically update when new project plans are created in the same workspace. For example: KPI=Number of late deliveries across all projects at a client I can create a metrics sheet and create a formula to pull data across sheets, but each time a new project is started, I would…