-
Can someone supply the proper syntax for calculating both budget and schedule variance?
Need to determine the budget percentage variance bewteen estimated and actual costs. In addition, need to do someting similiar for project schedule variance. Need the exact syntax for a column formula, apparently I am doing something wrong.
-
Alerting Someone
Hi We are using the PTO & Project Staffing Template set and I would like to know if I'm able to set up an alert if someone exceeds their hours for the week? Currently it only shows as red on the Master Resource Roll up so, users are having to constantly flick between the two sheets to see the week they have over allocated…
-
Is there an alternative to =SUBTOTAL in Smartsheet
Hi Guys, Trying to to find a formula that will allow me to sum a row based on the filter that I have setup on the sheet. I've included a screen shot of the filters I have on the sheet as an example. I have created a summary formula to count the column but I need this to change count based on the filter options I choose.…
-
Automation
Is it possible to include functions in workflows??? For example, everyday @ 11pmEST, I want any rows that have "Completed" checked AND that are 60 days old or more from that days date, to move to another smart sheet. Please advise if able.
-
Formula to match Payment Terms to a number (Nested If Formula)
Hello, I am trying to match a number based on the value of Payment Terms. For example if Payment Terms if NET 30, NET 45, or NET 60 I want to make a formula in a separate column that match the number portion. For example Net 45 should become 45 in a separate column. My formula only seems to work if the Payment Terms is NET…
-
Mutiple If Statements
I have looked through this thread and can't figure out what I am doing wrong... In quiz results, for scoring, I want column 1A to flip the numbers of Column 1. 1=5, 2=4, 3=3, 4=2, 5=1 =IF([1]@row = 1, 5, IF([1]@row = 3, 3), IF([1]@row = 2, 4), IF([1]@row = 4, 2), IF[1]@row = 5, 1) How do I get this to work?
-
COUNTIFS formula help please
Can't figure out why this isn't working. I get #Incorrect Arguement =COUNTIFS([1 Weeks Tasks]$2:[8 Weeks Tasks]$100, =1, [Task Owner]:[Task Owner], ="Copyedit") I'm trying to get a count of how many '1''s in the designated row/columns (1 Weeks Tasks:8 Weeks Tasks) AND if Task Owner is Copyedit. The trick , I think, is that…
-
COUNTIFS Referencing Other Sheets
Needing help with the COUNTIFS and referencing other sheets. It keeps coming back #unparseable I am trying to find the number of projects in a certain phase based on who the project is assigned to. Active Leads Range 11: Assigned to Active Leads range 10: Phase . =COUNTIFS({Active Leads Range 11}:{Active Leads Range 11},…
-
Referencing Sheet using three attributes / one being NOT EQUAL TO
Hello - am am running a VLOOKUP to 1 sheet, and currently pulling 2 attributes, which works. (see below) =COUNTIFS({Function}, "Category Management", {Period}, "S-Cl", {Status}" I want to pull the Function name (above), a Period (above) and avoid pulling any Status that equals, Complete. I can't seem to locate the right…
-
If Cells not blank equal max date
I have a sheet with 7 columns that have dates (was checkboxes but could not get it to work) I want an 8th column to populate the max date from the 7 columns ONLY if all columns have a date entered. Basically I am tracking when people submit multiple documents, once all are submitted (i.e all dates entered) I issue them a…
