-
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…
-
Conditional date formula
Hi, I'm having a little trouble creating a formula for a date column. I have a 'Project type' column and a 'Project start date' column which need to determine what the 'Handover to support date' column is. Basically - for all projects the 'Handover to support date' has to be 1 month after the 'Project start date' apart…
-
Formula Help
I have a formula that says it is an incorrect argument. When I break up the two arguments they each work, but they are not working together. The error message is incorrect argument. I don't know why they work alone, but will not work together. Here is what it looks like when I added them together. Can someone tell me why…
-
Formula in "% Allocation" column does not copy to new rows
I'm having trouble getting a formula to copy when I insert rows. I know about the trick where the formula has to be in the row above and below the new row, that's not the problem here. I have another formula in the sheet for status and that one copies to the new row just fine. There seems to be a limitation with the "%…