-
Input/auto fill data from different rows
Hello, Please find the example photo I would like if there is a formula that can auto fill and input data in blank columns/same row once i type the phone number (in column phone) by calling or looking up for the data from other rows in same sheet (or from other data pase sheet) taht engaged with same phone number. For…
-
Converting Excel Formula to Smartsheets
Hello, Could anyone help me converting this formula into a formula acceptable on Smartsheets please? =IF(H13="","",EDATE(H13,INDEX($P$2:$P$10,MATCH(G13,$O$2:$O$10,0)))+INDEX($Q$2:$Q$10,MATCH(G13,$O$2:$O$10,0))) I keep getting the #UNPARSEABLE error. TIA
-
Fill in project number based on ancestor level
I want to auto fill the project_number between the the Purple and Red rows. So all the children of Purple Project have a Project_Number = 4 and all the Red Children have a Project_number of 7 Tried using something like this. So if the Project is checked return the Project_Number. This give me "UNPARSABLE"…
-
date range formula
Hi dear community, I need a formula to return the values "Process" and "At Risk" when a certain date is reached. I have a "Start date" column. I need to notify the assignee of the status for each task (all in separate columns). When we are 145-91 days from the start date, it should return "Process". When we are 90-0 days…
-
IF AND/OR plus a VLOOKUP
I'm having trouble getting a formula correct; I keep getting unparsable or circular reference. I'm wanting to add the name of our rep based on the status of two columns. If the CRM Portfolio is checked AND the Jurisdiction = Federal, I want to insert the name "Jason". If the CRM Portfolio is checked and the Jurisdiction is…
-
Simple Inventory Formula
Help, maybe I am overthinking this or going about it all wrong. I'm trying to create a SIMPLE inventory tracker, it does not include costs. I have a request form where users request an item and I want to subtract it from the existing stock on hand, be able to replenish inventory and adjust inventory if someone audits the…
-
Formula for Status Summary Report and Project Task Completion
Hi Smartsheet Team, I have the following charts. Left one, I retrieve the data from Status Summary Report. On the right side, I have the formula to calculate the Project task completion. However, you will see the complete % is different between these 2. My "Not Started" in Sheet Summary formula is =COUNTIFS([Count of…
-
Formula to Link PTO Tracker to Project Schedule
Hello, I have created a PTO tracker to log my project team's PTO during the project lifecycle. The PTO tracker that I created is a separate sheet from my project schedule. Is there a way that I can create some conditional formatting (maybe via a checkbox helper column) to link these two sheets and indicate where there is…
-
Delimit Date/time in a match/index function
Hi all, I'm using a match/index function currently to pull over data from another sheet. Currently I'm using this: =IFERROR(INDEX({Google Sheets PTI Daily Form 6/19/23 Range 7}, MATCH(claimNum@row, {claim num}, 0)), "") The sheet I'm referencing in the function has time and date in the same column, so the above formula…
-
How to subtract percentages?
I created a new column % Not complete and am trying to add a formula to have =100%-[%Complete]@row. Answer #UNPARSEABLE I have also tried =100-%Complete]@row. Answer: This will populate an answer, however I cannot adjust the formatting from % to number Example: %Complete = 13% Correct answer should display 87% Second…