-
Develop a ranged function that stops at the row above
I am trying to develop a function that will collect the maximum value in the same column for all rows above the current row. My initial formula was =MAX(COLLECT([Sim Exp Yr]$1:[Sim Exp Yr]1, $[Email Address]$1:$[Email Address]1, $[Email Address]@row, $Certification$1:$Certification1, CONTAINS("SimLab", @cell))) Which runs…
-
Formula help please! What formula to mark the parent row "Complete" with an "Not Applicable" task?
In my status column I am using this formula auto update my my parent row: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(), "Not Started") > 0, "In…
-
Need formula to remove characters from a column when added
We export data from another data source and cut and paste it in the Smartsheets Column AOY Status. The issue is after we cut and paste the data there are going to be certain characters I need removed. For example: The data we cut and paste in will have Down <20 days or Down >20 days. When we cut and paste that data I would…
-
Formula to calculate the difference between two numbers based on a month in another column
I am unsure if it is possible to do what I want, but I wanted to ask. I have attached a copy of my grid. I want a formula to calculate the difference between the largest and smallest numbers for each well for each month. For example, for well #2 in month one, find the largest number (58650300) and subtract the smallest…
-
Get the DisplayValue of a Hyperlink
I have a column of currency values that are hyperlinks to receipts. I want to total the column but the SUM function does not recognize the displayvalue (the currency amount). How do I Get the DisplayValue of a Hyperlink? Thank you in advance
-
Field Type: Related Sheet
There should be a way to link data from Sheet A to Sheet B. For Example, we have a sheet A to track all of our vendor demographics. We then have sheet B for tracking invoices. On that sheet we have a column for Vendor. We have to maintain our Vendor Sheet and then update the Vendor column on the AP sheet so the drop down…
-
Perpetual Contract Renewal Formula
Hello All! I am trying to create a formula that will automatically update the end date to a contract based on a renewal timeframe. For example, Contract Start date 12.31.19, Contract end date 12.31.20 at the end of the contract, the contract will renew for 1 year perpetually on the same date. Right now we are at 11.8.24,…
-
Triggering an automation from an attachment revision
Hi - I am trying to trigger an automation when I upload a revision to an attachment. I already have the document generated by changing a field and then when I upload the revision, I want the same field to change again. For some reason, I can't seem to trigger from the revision. I tried setting the trigger to a new…
-
Use a Master Smartsheet for high level tracking and individual smartsheets to flow into Master Sheet
I am hoping to use a master smartsheet to track KPI's and individual tasks for program management. I would like this data to be duplicated to other smartsheets so individuals all have their own smartsheets and the updates from the individual sheets can be automatically update in the master smartsheet. I am trying to use…
-
How can I set up an automation to send a message when a team member celebrates work anniversary
I’ve created a sheet with team members' names, their anniversary dates, and a column showing the current year's anniversary date. I want to set up an automated email system that sends a congratulatory email to employees on their work anniversary. Could you guide me on how to achieve this automation?"
