I get #unparseable. =SUMIFS(Effort Hrs:Efford Hrs,Assignee:Assignee,"Easton",Sprint Week:Sprint Week,"32") Effort Hrs = Hours worked Assignee = the person Sprint Week = the wee it is done
I have a sheet that lists hundreds of inventory items. The sheet has columns with checkboxes indicating if a given item is included in a specific shipment type. I'd like to create a new sheet that pop…
Hi All, I've referenced the forums for help and thought someone might help me with the "unparseable" error I am getting. We are trying to do complex formulas: =COUNT(IF(FREQUENCY([Listing Key]2:[Listi…
Hi all, I'm looking for a way to enter a hyperlink from another local shared drive in a Smartsheet cell. Is this somehow possible? Thx for your help! Warm regards, Gonnie
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add s…
I would like a way to determine if a cell contains a literal value or a formula calculated value. For example: On a project sheet we have multiple date fields for different actions to complete on the …
I am trying to make a column with stars that is starred when a date is filled into the completion date column past the due date. The only problem with this is that we have a recurring maintenance shee…
Hello:) Is there a way to lookup a date, determine if it falls between 2 dates (fiscal year quarters), and then return the corresponding value? ie: Date: 1/29/2016 Fiscal Year Q1: 1/1/2016 ~ 3/31/2016…
i have a column titled # Wins and wound up with a percentage towards my Wins goal. That said i want to use RYG lights based on how close i am to the goal. So here's what i wrote but i know i'm missing…
I have an "Assignment" form that creates a system generated number. The crew foreman will use this form for their assignment, then they will populate a "Production" form using the system generated num…
