-
How can I copy parts of one sheet to another
Good morning! I am hoping someone can please assist me. I have two sheet. Sheet A is a Master Staffing Roster PM's maintain. They use this everyday. There are times when information from the Master Sheet needs to be inputted into Sheet B. Rather than the PM's typing it out I would like to automate it so only specific cells…
-
Networkdays formula syntax error
I used the AI formula builder to create a formula to calculate the number weeks (weeks out) between a launch date and milestone dates. I want the weeks out to always be positive. When I try to convert the provided formula, which works in the cell I place it in, I get a syntax error. I can't figure out the error.
-
indicate yes/no if date is between dates
I'm trying to incorporate a simple indicator on whether or not a task was completed within the appropriate timeframe. the timeframe is +/- 30 days from the date due column date. I've tried a number of formulas and none of them seem to be working and I can't figure out why. Is it because the earliest/latest dates possible…
-
Math Logic Formula - IF THEN ELSE?
Hoping someone can help with what I think is an IF, THEN, ELSE logic math calculation. I created an IF, THEN formula but now need to step it up. Need to create a formula that will calculate an amount due based upon a previous formula but there is a minimum and maximum ceiling to the amount that can be due. We enter an…
-
IFERROR, INDEX, MATCH, IF(AND( Formula for 5 sheets?
So, this is a doozy. I am trying to create one report that, when one piece of information is entered, pulls the rest of the necessary information from across five other sheets. I have seen a discussion on this forum about doing just that thing, but the difference is, I need to include certain criteria within the search,…
-
Enabling date columns to be incorporated into formulas
I have built a milestone report. To keep it current, I am asking my team to update 7 columns (for 7 milestones) every week in the weekly updates sheet, so I can track. In my sheet summary I am then pulling the most current values from the weekly update sheet. It is an Index Match formula, but it only can pull the date when…
-
Notifications
Hi Brain Trust I have an automation that when the status is changed to onboarding a notification is sent to xx@xx.com.au. HOWEVER - when several rows are updated in quick succession and then saved, the notification sends out a combined notification instead of individual notifications We tried changing to update the status,…
-
(AED) currency is not listed in the currencies
Dear Community, Can we have (AED) United Arab Emirates as one of the currencies to be used in Smartsheet? I would like to use it in my budget sheets Thank you Sara Hamam
-
Index Match with multiple Parent/Child rows in a sheet.
Hello all, I'm looking for some advice on a tiered IF statement using index/match and CHILDREN formulas. My case: I receive numerical data from another metric sheet that copies it snapshots into this archive once a month. There may be times where we need to edit the historical data. To ensure the % columns are updated I…
-
Join(collect()) - the collect column has multiple values.
I want to filter what is collected (in the collect range, each cell may have multiple years : e.g. 2020,2021,2022,2023,2024). 2 criteria are separate columns. Criteria range 1 vs criteria 1 (wood species), criteria range 2 vs criteria 2 (specified in product). Both criteria 1 and criteria 2 match, so I get all the years…