-
Linked Sheets and Dragging Rows
When dragging rows to another sheet, is there a way to keep the information from the Parent sheet which to information is being pulled from? This would obviously automatically create linked cells back to the parent sheet that the information is dragged from. Is this possible? Current Process: My company is basically trying…
-
formulas disappearing
I'm having an issue with the formula I created to automatically check a box disappearing if I happen to manually check that box. I have it set up so when a certain box is check marked this will cause another box to then be check marked. I'm wondering if there is a way to override the formula immediately disappearing when…
-
% Completed and Task Finished
I would like to have the % completed set automatically to 100% when the Task Finished is checked. Any suggestion on how to do that? First smartsheet struggles...
-
Getting top x rows
Hi all We're working on a dashboard for senior stakeholders. At the moment we have a report that is an amalgamation of several sheets (listing risks & issues). We now want to limit that amalgamated report to only show top x rows, based on one of the columns (numerical value). So, instead of the current report showing all…
-
Formulas looking up data from other sheets
Is it possible to create a formula in one sheet that looks up info from another sheet? I dont mean linking cells - I need to be able to set an IF statement based on the input of one column in another sheet. You can do this in excel so im wondering if Smartsheet also allows for this.
-
NETDAYS Formula
I cannot for the life of me figure out why the NETDAYS formula is not working for me. Let's say I have my start date as 6/30/17 in cell 6 under column 2 and that my finish date as 7/26/17 is in cell 6 under column 4. I select the appropriate cells for start_date and finish_date and my formula reads…
-
When are the LARGE and SMALL formulas coming?
Can we please get an update on these formulas? I was told quite a while ago that large and small formulas were being added, but 2 product updates have come and now I am not getting a response in the original thread about ETA's. https://community.smartsheet.com/discussion/formula-help-top-5-list-aka-large-formula#comments…
-
Auto-fill form/cells when a certain item is selected from a drop-down
I was wondering if it is possible to auto-fill cells based on an item that is selected from a drop-down. I am trying to create a form for our subcontractors to upload submittals and I wanted them to be able to select from a drop down list what they are submitting. I.E. Product Data for Paint, or Samples for flooring. Once…
-
Intermittent #blocked error
Using the formula below in combination with predecessors (FS -5d) I get an intermittent #blocked error. Sometimes when I make a change (add a date / change predecessor) it goes away. I can make a change, undo the change, and the error is gone. What am I missing? =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red",…
-
Show who modified the value in a specified column
Background We create and approve purchase orders via Smartsheet. On receipt of the invoice to the accounts team the named approver (Contact List column) for the PO is sent an update request with the attached invoice and the field "invoice approved". They review and check the box, submitting the update. There are 12 invoice…
