-
Average of lease $ amounts in a certain region
I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has been checked and to specify a region (I do a cell reference) it doesn't seem to work. For instance, in 1 region I do not…
-
Formula from hell
I have ranges of data in multiple forms. There is criteria that must match from each to be summed on a third sheet. The criteria are GL Accounts and a month Code. One of the month codes is listed as 12 Month. The intent of that code is to signify that the cost in one of the columns should be spread across 12 months. So I…
-
SUMIFS
I am trying to sum accounts receivable for individual salesmen. I have gotten to the point where I can add if the check box under [Check Received] is marked but I do not know how to sum if a check box is unmarked. So far my formula is returning 0 when it should be returning a over $100,000. This is my formula so…
-
Smartsheet connection with Alteryx workflow
Hi, Someone facing an issue to connect data from Smartsheet into workflow in Alteryx? I have an Alteryx with data connected from Smartsheet that always worked well, but last friday the alteryx wont able to connect with Smartsheet, the message in Alteryx is "No valid Fileds were selected. This connection between Alteryx and…
-
Limiting Access to Hyperlink
Is there a way to prevent the other sheet user to open the a link/URL hyperlink to any row, whenever someone else is using the same link?
-
Automatic Form Repsonse
Hello, I have a form in which staff submit their mileage journeys. In the smartsheet (not the form) I then have a column which totals all their journey miles to give the total mileage completed and the amount to be paid to them which the person submitting doesn't get to see. Is it possible to set the sheet up so that an…
-
Bank Statement Checklist and weekly notification of missing statements
Good morning, I am trying to build/find a Bank Statement Checklist that will notifiy me of all missing bank statements. For example, as of today, we should theoretically all bank statements from October 2018 and prior. I would like a monthly email sent out notifying me or somebody of all missing bank statements. I am…
-
VLOOKUP - I think?
I am doing estimates for projects. Each job title has its own rate and there are different rates based on specific clients. What would my formula be if I want to reference a particular cell based on these two parameters. They would live on a master rate sheet that could be referenced.
-
Countif Formula
Hi everyone! Im having trouble with a simple COUNTIF formula. I am getting "UNPARSEABLE" but for the life of me, I just don't know what I'm doing wrong. I want to count how many times the "Weekly Goal" was met in a range of cells. screen shot attached.
-
Email based on cell value?
Is there a way to send an email containing the data from a row automatically based on the value in a cell? For example if they choose "Accounting" from a dropdown list or contact list in the "Department" column in row 1, then it would email the data from row 1 to the address on file for the Accounting Department.
