-
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…
-
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…
-
Find and Change Resources in Alerts
We have a staff person (A) that retired and is being replaced by another staff person (B). I ran a report to tell me where she (A) was allocated as a resource in the various sheets, and was easily able to change those tasks to the new resource (B). However, I know that the retired person (A) also received alerts based on…
-
Is there a column or range limit to Vlookups?
Is there a column or range limit for Vlookups? My Weeknumber I'm referencing is in column 1 and the number I need is in column 33. The error its giving me is #Invalid operation. It seems that I can handle 31 columns but anything after that, it gives that message.
-
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"…
-
Hierarchy in Smartsheet and Jira Connector not working
I don't seem to be able to get any hierarchy to work using the Jira connector. Smartsheet Hierarchy When I first sync'd my smartsheet with Jira all the rows were rearranged and the entire hierarchy in smartsheet was lost. So I figured out I need to use Group by in the Jira connector to respect the Smartsheet hierarchy.…
-
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…
-
Financial/Accounting needs to expand Smartsheet in our company
I don't work in this realm at my job, but I know that another program (much more costly, I might add!) is being considered to meet our business services group needs. Though not exhaustive, I know they need a program that will allow for processing of purchase orders and needed approvals (electronically), timekeeping for…