-
Vlookup + sum in a column
I am creating a template for keeping track of employee's leave. Column "Accumulated Leave" has the vlookup function to return the "leave days" taken by employees. the formula I have is as below: =VLOOKUP([Employee Name]3, $[Employee Name]8:$Duration50, 5, true) However, when I show the same employee on an another row, it…
-
Parent Row Roll up using a specific text value
Community: I am piggy-backing off Nathan Skyers' request from November 24, 2016 1:13 pm, regarding Parent Row Roll up, as I need a very similar formula. Any help will be appreciated. Thank you, Sandy Is it possible to have a text value show in a parent row whether all statuses match my criteria OR if even one status…
-
Cross Sheet Reference Unparseable
I am trying to use a COUNTIF statement to reference another sheet and count the number of "V" s so I can create a metrics sheet for my DashBoard Creation. I have attached a snip of it below but all i get is #UNPARSEABLE when i try it. I must be missing something, but I am unsure as to what. Received the #INCORRECT ARGUMENT…
-
automatically move date from one column to the next
I wondering if there was a way to move data from on column to the next when information is inputed into another column. For example if I create a column in front of wk 1 allocation% and input a %. I would like week 1% to move to Week 2, week2 to move to week 3 and week 3 to move to week 4. Week 4 can just go away or I can…
-
Counting Dates within a range
I am trying to get a count of the number of rows with dates that meet one or another condition. I know I cant use Countif so I planned on adding a column next to my date column to capture the data. One condition is that the date is either within the next 30 days OR the date is in the past. Here is what I have so far and it…
-
Is it possible to count a Blank Cell only text is filled out in another cell?
Currently I'm using this formula =COUNTIF(Status:Status, "") to summarize all the blank cells in the Status column. The issue is that it also counts the Status cells that are just blank rows at the bottom of the sheet. Is there a way to count only the blank Status cells if there is also information populated in the…
-
Invalid date causing error in Formula
I have formulas written based on a date but some of the dates in my sheet contains blanks or text. So in my formula, it is giving me an Invalid Data Type error. Is there a way to determine if the date is valid date in the formula? I can check for blank, but dont know how to check for anything else. Can you use ISDATE in…
-
Formula Query
I'm at a loss for how to perform a desired calculation within a sheet. I have a list of rows that are assigned to owners (contacts). Each row has a % complete. I want a formula that will tell me what a given contacts overall completion rate is. * Look up name in Owner column * Add up all percentages in the "% Complete"…
-
Formula not refreshing when date changes - Can't tell I'm connected?
Hello ~ I'm new to Smartsheet and would appreciate some assistance. I have a formula that changes the color priority as the next action due approaches or passes, reflecting if the task is pending action from others: Rows that are marked "Done" then gets conditionally formatted to Grey (this was a workaround to not having 5…
-
Formula assistance:
Hello, I am looking for some assistance with how to write a formula that will auto-fill a check box. I only want this checked if the Parent Cell column is blank and that the Assigned to is equal to the user. Currently, the formula I use auto-checks is the Assigned To contains the user's name. Any advice on how to modify…