-
COUNTIF formula calculating a checkbox column incorrectly
Hi there There is most likely an easy fix to my issue, but I just can't crack it myself: I have two COUNTIFS formulas to calculate how many checkboxes are ticked and how many are unticked. The COUNTIFS formula for the ticked checkboxes is working 100% - there are 5 check boxes ticked, which I counted manually to confirm…
-
INDEX, COLLECT, CONTAINS Formula help
Hi! I have a formula that is working the way I want... =IFERROR(INDEX(COLLECT({LFH Date}, {LFH Date}, @cell > TODAY(), {LFH Analyst}, Name@row), 1), "") But when I add another condition, I get #INCORRECT ARGUMENT SET. This is the formula: =IFERROR(INDEX(COLLECT({LFH Date}, {LFH Date}, @cell > TODAY(), {LFH Analyst},…
-
Return a value from the previous month in a reference sheet
Hello, I'm trying to bring in the average score from the previous month in a reference sheet, it's returning an error. Here's the formula in text: =IFERROR(INDEX(COLLECT({Archived ATL Audit Scores - Combined Average}, {Archived ATL Audit Scores - Combined Area}, Area@row, {Archived ATL Audit Scores - Combined Concourse},…
-
Is it possible to filter out submissions from a form based on if the email field?
Hello, I am learning smartsheets and am unable to find a way to do this. We have a form for one of our sheets so people can submit requests to my team. However, we want the requests to only come from our organization. The form obviously has an option to only allow submissions if they have a smartsheets login but that…
-
Average with multiple criteria
I am trying to get the average of a column named "Average working Days" while the "STATUS" = "On Hold", "In Progress" and "Not Started" and when I tried it, it gives me #Divide by zero. =AVG(COLLECT({Request Tracker with Form Range - Average}, {Request Tracker Range 3}, Category@row, {Request Tracker Range 2 - Status},…
-
Translation of Excel Formula to Smartsheet
How do I go about translating this Excel formula to Smartsheet?
-
Help with Parent/Child and Sum Formula
Overview: I have a project plan (below) with a column for the user to enter remaining work effort/hours to complete a task. We also have milestones (checked tasks Main Task A, B and C in example). It is also possible for the users to enter additional tasks, so I will need to be able to capture new tasks as well. Objective:…
-
Self-Update Solution - Enabling [outside] users to edit previously submitted content
If you host a set of records that "belong" to others, and you want them to be able to edit their records at any time, check out this dashboard as a seedbed of ideas for how you could achieve this. Please suggest other wording I could edit into in this title or entry to help people find this. I'm doubtful "self-update" is…
-
Smartsheet Help
Good morning! I am trying to figure out the problem with this formula. I have two sheets and I want one sheet to communciate with the other. The example is that in the first sheet if the ship has IRP formatting as new then in the second sheet it would mark the ship with a checkmark. Below is the formula: IF(AND({SHIP…
-
Status Formula
I keep getting an error stating circular reference and I don't understand why. Here is what I am trying to accomplish: If Employee Separation Date is in the future change [Status] “HOLD Pending Separation Date" If the Employee Separation Date is NOT in the future AND “All HR Tasks” is NOT CHECKED change, “PERS Packet…