-
Formula - IF/OR
Hello, I am attempting to take the SUM of one cell and divide it by a range of other cells to get a percentage output. However, when creating the formula I am receiving an "#Incorrect Argument" error. I need the range in the column(s) because the column "Region Name" will fluctuate with the entries that are made from the…
-
cross-sheet formula to count dates before or after today
I've searched the site and haven't been able to find anything that works, so appreciate any help available. I have a lot of sheets that link to one another, one of which is pulling launch dates (for events) from various other sheets, and end dates from a single sheet. On another sheet I am pulling various metrics, and…
-
Assigning a value to another Column from a formula...
Hello All, I hope you are all well and safe. I have a sheet that has the following columns: 1st Level Approver, 2nd Level Approval Required, 2nd Level Approver, 1st Approval, 2nd Approval columns and Helper. 1st Approval and 2nd Approval are Single Select drop downs with the options "Approved" and "Declined" I need these…
-
Formula to pull through names of all projects relating to a programme
Hi I'm looking for a formula that will reference a sheet that holds programme and project names. I want to pull through all projects related to a particular project. How can I best do this? I did put it in a report but, on my Dashboard it means I can't pull the data through on my metric widget. I don't want it to show on…
-
Sum Values in Matrix
Hello, I'm trying to sum all the values in a 2 axis matrix that meet a criteria for row and column. Name on rows and columns could be repeated. In the example of the image the result be 11. Thanks for your help.
-
Publishing a Report
And question #3. LOL Thank you again Smartsheet Community for all your assistance. I am the owner of both the spreadsheet and report (which was created from the spreadsheet). I want to publish in Gantt and am getting the following error. Any suggestions:
-
#CONTACT EXPECTED
Hi All, I am trying to make smth in Smartsheet work; tried everything but it doesn't work. In a sheet summary, I am trying to count how many times a name appears in a Contact list column. I use following formula: =COUNTIF(Owner:Owner, "name@email.com") but it throughs following error message: #CONTACT EXPECTED. I also…
-
complex if/and/or question
I have 5 status columns, each with 4 possible values (Approved, Approved with Comments, N/A, Resend). I want to fill in an "Overall" Status The 5 columns are __________________ Tagless Status Front Graphic Status Back Graphic Status Right Sleeve Status Left Sleeve Status Other Status My logic is If all of the columns are…
-
Financial Year Saving Based on Implementation Date
Hi All, I have a sheet to track cost savings and would like the financial year savings to change based on the implementation date. The three fields are: Implementation Date - restricted date field. Savings Full Year - the overall savings throughout the full financial year, 01 July 2020 to 30 June 2021. Savings Financial…
-
I Need help with formula to prevent AVG Parent percentage from rolling up.
I have several (18 rows to be exact) rows that I am need to get the AVG percentage for. 17 of the rows are currently at 100% and 1 row is at at 92% (because there is one step still left to complete before it can be at 100%). When I do the formula AVG "Children", it wants to round up the percentage to 100% (the actual…
