-
SUMIFS; Need to know how much time is allocated to each cost center by employee
I am trying to figure out how much time is allocated to each cost center for each employee for the 3rd Qtr. Placing a formula into a metric sheet trying to reference the original sheet didn't go well, so I moved to using the below formula in the "sheet summary' in an attempt to roll up how much time per one cost center…
-
Forecasting Scopes of Work
Hello all! I am looking to do some forecasting! I have Data from a third party application that I bring into smartsheet as its own data. It has a Start Date Column, and End Date Column, a Duration Column, and a scope of work column. The Scope of work is consistent from Row to row, depending on what the scope entails. I am…
-
counting a name that appears in a multi select dropdown
i am trying to count the amount of times a name appears in a sheet (Column) the formula below works fine if a cell only has one name however if a cell has multiple names it will not count it from that cell, the formula i am using is =COUNTIFS({SNOW - ARIaDd Log assigned to}, $[Primary Column]@row, {SNOW - ARIaDd Log type},…
-
Does anyone know how to convert this SUMIF Formula and REF a date from another sheet
Hi, Were looking to take this active formula which is currently working and replace the date ranges from another sheet (Cross Sheet Reference) . Does anyone know if this is possible ? Because it is time consuming to replace the date range on each formula, we want to be able to edit the date range from another sheet.…
-
Ancestor and Checkbox Formula
Hello! I'm trying to write a formula that I just can't seem to get right. I've got a project with several ancestor levels that I'd like to report on. I'm close, but I just can't seem to get it. I've added a Parent Row helper column with a check box. I'd like the check box to equal True (checked) if the Primary Column is…
-
Function best for Evaluations
This snapshot is from our company's evaluations of our employees. Now we are looking to populate the "MARKS" Column. The equation should read in the Attendance@row:Efficiency@row cell range, if it finds "Excellent" it populates a Green Status Bubble, if it finds "Good" it populates a Gray Status Bubble, if it finds "Fair"…
-
How do I change the formula in the Metadata sheet so that I can include data from two columns?
Hi Smartsheet Community I am trying to edit a donut chart that displays projects by Change Impact (High-Medium-Low) across all stages (Initiate, Plan, Implement, Close, Closed) - while excluding Closed projects. Currently my data is taken from the metadata sheet - which unfortunately doesn't include the distinction by…
-
Summary field = date selected from project plan
So I have a standard project plan with timeline / gantt chart. Start date = [Start] and end date = [Finish] I have several mini projects in my smartsheet so have used the level calculation to detect level = 0 for start of my mini projects with levels 1 onwards for the children tasks I have successfully written the formual…
-
Conditional Linking
Hi Guys, Have delved a bit into linking sheets and writing functions etc. in the past but I am starting to get out of my depth - Is there a way to intersperse the two, so something like: If X then LINK So IF Sheet1, column X is ticked, then LINK the contents of those rows in Sheet 1 to Sheet 2 =IF(sheet1columA), "1", LINK…
-
How can I apply this formula to the entire column?
I can't seem to apply this formula to the entire column. it tells me that the column syntax formula isn't quite right. =IF([Closed Date]1 = "", TODAY() - [Entry Date]1, [Closed Date]1 - [Entry Date]1)