-
How do I update multiple cells when one cell is updated?
How do I update multiple cells when one cell is updated? Example A: If Done is checked, then Status is updated to Completed and Progress is updated to Full. Example B: If Status is updated to Completed, then Done is checked and Progress is updated to Full.
-
Help creating a formula
Can someone help me fix the following formula? # of Travel Trips = IF(([Onsite Delivery]@row = "Onsite" , [Software Installation Hours]@row >40, 1, or <41-79, 2, or <80, 3) * [Number of Sites]@row)) Not sure what to do with the ORs...or how to include them all into the formula. Do I have too many parenthesis?
-
Sum of Max Value across multiple rows
Hello, I need some help working out a formula that will let me sum the max value across 2 conditions... I have a data sheet that is getting rows copied to is when values are changed on multiple project sheets and i need to have a formula on my report sheet that returns the sum of the highest value in a day for each…
-
Is there a formula for referencing a different cell daily?
I've automated emails to send out schedules to our field employees but their sites can change daily and I was wondering if there's a way to reference a different cell everyday so I don't have to manually change the site cell in the automated workflow.
-
Formula help: Check box if field in another sheet is a date
I am attempting to use an IF statement with an Index(Match( to check a box in my target sheet if a matching field in my reference sheet is a date. I am attempting to match the Vendor Names between the two sheets and have used the below formula but am getting a #NOMATCH error. =IF(ISDATE(INDEX({Contract Management - Sub…
-
Counting number of tasks per Assigned To contact
My task list contains parent, sub-parent, then children tasks. The workstream leader is assigned to both the parent and sub-parent tasks, and possibly sub-tasks as well. I need to count the number of tasks per "Assigned To" contact. It would be ideal if parent tasks are not included in that number, but it's manageable if…
-
Differentiate sections in master gantt chart with different colors to show different projects
I created a master gantt chart where the beginning and end dates are linked of different projects within one branch of the business. So each line would have columns like the below with the gantt chart to follow. Project 1 | 60 days | 3/1/21 | 6/1/21 Project 2 | 120 days | 3/1/21 | 9/1/21 Is it possible to show a particular…
-
How to number the duplicate by Sequence or Order?
Hello there! I need help on finding duplicate values to my table and then put them in sequence or Order. Thanks in advance.
-
formulas doesnt work when updating data from external source
I'm using Appsheet integration to extend the functionality in forms. I encountered a problem when trying to use the SUM formula - when a data is updated inside the columns from appsheet or another source (i only updating numbers) the formula in smartsheet doesn't recognise it and when trying to sum the numbers it shows as…
-
AVG(COLLECT)
I am attempting to average a column where the assignments are now closed (or past the due date) for the year. The Year@row is 2021. =AVG(COLLECT({Row Averages}, IFERROR(YEAR(@cell), 0) = Year@row, {QAlerts Closed}, 1)))