-
How to FIND if the grandparent or parent has a particular word
Hi, Is there a way to find the Grandparent or Parent has a particular string/word? I have tried PARENT(PARENT()) and ANCESTORS(), didn't work. Appreciate any help.
-
Pulling Tasks into a Report Using Multiple IF(AND( formulas in the same cell
My ultimate goal is to pull data into a report from a project plan. I want to pull: * Current tasks (Tasks where TODAY falls between the Start Date and the End Date) * Upcoming Tasks (Tasks where the Start Date is within the next 7 days) * Previous Tasks (Tasks where the End Date is within the previous 7 days) * Late Tasks…
-
Budget vs actual calculation
Hello, I was wondering why the formatting of this document is auto-crossing out the actual calculation? Is it suppose to be doing this? Is there a way to make it not do this?
-
FORMULA - Pulling Data from last row filled
H E L P P L E A S E I have 5 rows (children) of possible data input areas. All 5 rows may not always be used. In Column "M" a number of 1,2 or 3 will be entered. Based on this number, Column "A" of the parent row should reflect "Closed" if the last row containing data is 1 "Work in Progress" if the last row containing data…
-
Automate RYGB and Children together
I have a standard project sheet. I added one column called Today that in Row1 links to a separate sheet that will be triggered everyday so that it gets Today's date (this gets you around using the Today function which only triggers when a sheet is opened), every row below that first row then has a =CellReference the cell…
-
Inbounds to Smartsheets from external sources
I know there are a few connectors for outbound (ODBC) data to all kinds of places but has anybody gone the reverse, i.e. inbound from, say excel, to a sheet. I get the reason to export into tools but I'd think there would be enough cases for being able to pull in data from other places. Anybody?
-
Overlay Google Calendar in SS in a grid
Im going to implement a time management report in the company to understand how the staff spend their time (meetings, planning, execution, travel, etc) To do this we use a name code in Google Calendar that enable us to automate the analysis, like this. * All meeting start with MEETING... * Task-related to projects starts…
-
#Unparseable error after saving from android app
For some reason my formulas are suddenly showing #Unparseable after the sheet was updated on the mobile app. Not sure what is wrong, can anyone take a look? https://app.smartsheet.com/b/publish?EQBCT=5682096f4bf44ebda10e855be7e57aa6 Ty M
-
Formula Help Needed
I need a status formula for the parent row of up to 5 children rows. The children rows have a control rating of 1-3 If rows 1-5 have a control rating of 1, the status column should reflect "Closed" in the parent row. If rows 1-5 is 2 or 3 then parent row should show "Work In Progress" If ALL are blank then status should be…
-
How to use Formulas to change the value of Symbols and Check Boxes?
I'm kinda new to this. I'm a little familiar with how formulas worked in Microsoft Excel, but not a pro in the slightest. I only know basic stuff. How do you use a formula to change the value of symbols and check boxes and drop down menus? Also, I've been having trouble pulling the data from dates. I always get the…