-
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…
-
Is there a way to know current sort criteria?
I got invited to edit a sheet, which I'm pretty sure is sorted. The sheet has way too many columns for me to quickly check the criteria. Is there a way to know what criteria the sheet is sorted on?
-
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…
-
Revision Control - Best Practice
With an AS9100 Audit coming up for us, many have asked if our Smartsheet templates need to be revision controlled. Does anyone have any insight on this they could share?
-
Line Item Transfer to Another Sheet using Formula's
I'm working on a project and am hoping for some advice from the community of experts! I have a sheet that serves as an ongoing list of projects and information about those projects - once a decision is made to either fund the project or deny the project, I'd like that line item to appear in another sheet. My main sheet…
-
Hide login button
I am dealing with people outside my company. I am sending them information in response to their web form submission that I have setup in Smartsheet. I would really like to use the discussion option but that invites them into my sheet, which I don't want. I just want to capture their replies. So I tried using send row but…
-
Report Builder, Using Include and Exclude on Same Column?
Hi, I was wondering if there was a way to get the Report Builder to filter both an include and an exclude in the same column -OR- get it to filter for an exact word or phrase. Example: Filter for a column is set to find all entries that contain the name "john" but that means that a bunch of listings that also contain…
-
Automation from 15 smartsheets to 1 Master sheet
I tried Zapier but ran into two issues. 1. all the sheets must be active all the time.. Zaps will not Zap unless a sheet is inactive. 2. I need the rows added to the master sheet added per division NOT at the top or bottom.. What am I missing? I know that I can copy and paste the rows which is ok.. Just wondering if the…
-
View formulas globally in a sheet
Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying the underlying formulas). I find this very helpful to: - Discover which columns I want to shade grey to indicate that they…
