-
How to simplify SUMIF formula
Hi! I need to pull data from about 40 core sheets into a monthly budget sheet. Each core sheet will have it's own row on the budget sheet and the header columns will be displayed January 2025 through December 2025. The formula I have works, it sums the budget correctly and places a "-" if the sum is $0.00, but to reference…
-
Does Smartsheet Desktop DeepLInker on Mac even work?
I like Smartsheet in a browser window and on iOS, and the price is reasonable. But the Mac Smartsheet Desktop DeepLInker app does not work. When I click the icon to open the app, it displays the message in the screenshot below. After clicking the "Quit..." button and turning off the Smartsheet extension OFF, and then…
-
Help with automation
Hi. I need some help with automations based on upcoming expiry date of contracts. I want to send an email alert when a contract id within 3 months of expiry date. Initially I created a helper/formula field using a formula field called DUCE (days until contract expiry) by using Contract date - Today() and set condition DUCE…
-
How can I format the sheet summary "sum" number?
I have a very simple sheet that has a column of numbers. Using a Sheet Summary formula such as =sum([column1]:[column1]) I get an answer, but it loses the number formatting - specifically the thousand commas. Since these are pretty big numbers, I need the commas to appear. They appear on the base sheet for the individual…
-
Help with error Incorrect Argument Set
I'm trying to use this formula =SUMIFS(CHILDREN([Reimbursement Amount]:[Reimbursement Amount]), [Reimbursement Date]:[Reimbursement Date], >DATE(2024, 1, 1), [Reimbursement Date]:[Reimbursement Date], <=DATE(2024, 12, 31)) But I keep getting the end message, incorrect argument set. I'm using this as a summary sheet…
-
I get and "#incorrect argument set" when I wrap my IF statement with IFERROR to replace the "#INVALI
I get and "#incorrect argument set" when I wrap my IF statement with IFERROR to replace the "#INVALID DATA TYPE". Please tell me what I am missing? =IFERROR(IF(MONTH([Incentive Date]@row) = 1, "January", IF(MONTH([Incentive Date]@row) = 2, "February", IF(MONTH([Incentive Date]@row) = 3, "March", IF(MONTH([Incentive…
-
Reference or copy a column in one sheet to another sheet automatically
Hi, I am trying to figure out a way to automatically get specific columns in one sheet, into another sheet I was originally looking at using a workflow to copy the rows over, but I only wanted to copy a subset of the columns which doesn't look to be possible. Then I started looking at cross-sheet references, but the posts…
-
Alphabetized Filter Dropdowns
It would be helpful if the "is one of" dropdowns in filters were alphabetized instead of listed in the order of most used. For dropdowns that have many different options, it is hard for team members to find the option they need in a filter when it isn't alphabetized. Example of Today Red (52) Green (43) Yellow (28) Blue…
-
Ability to modify report filters on mobile devices
Please extend the capability to modify filters within a Report to mobile devices. This feature, presently accessible on desktop, should be available on mobile platforms too to enable on-the-go adjustment of parameters. The absence of this functionality currently compels Report creators to generate numerous reports in…
-
SUM FORMULA BASED ON MULTIPLE CRITERIA
Help PLEASE!!! I am looking for a formula that will sum the total travel cost of resources, if selected, based on the qty of each resource and also the resource rate (from another data sheet). For this example I have 3 travel items: Line 1: I have 3 resources which will be traveling, project manager, design engineer and a…