-
How to set a formula for 3 different values to prevent any duplication
Hello Everyone, I hope all are doing well. I'm facing an issue to find the suitable formula to my case taking into consideration i'm a newbie here in smartsheet and would appreciate your kind support. The formula i'm looking for is targeting 3 main columns : Start Date, End Date & Facilitator. To assure that if a…
-
Can you copy / export workflows, conditional formatting and saved filters to other worksheet
We stated using Smartsheet back in November and I have a few active Smartsheet for projects and more we use it the more I find things I want to do across all sheets. If I add a workflow, conditional formation or saved filters to a sheet is there a way to export them and import them into another sheet? I know I can use a…
-
Notifications and Workflows Not working
Hi We have picked up an issue around the sending of the notifications- we have had several email addresses that the notification will just not send to - we have checked that the correct email has been shared to the sheet- that the correct email is in the notification automation - we have checked that the email is in fact…
-
Vlookup or Index in a date column
I have read all the comments relating to the above, but nothing works for me. So I had to Link a cell, which means that if a row or column is added, I will have to amend the link. I just wanted my Start date in a Gantt at Task@row to be able to look for this Task@row in another Gantt sheet and come back with the…
-
Crosssheet Formula
Hello, I am trying to do a cross sheet formula. The formula below is what it looks like in the original sheet and the formula works. Now I want to pull the data from the original sheet into a new sheet and the cross referencing is not working. Any assistance would be greatly appreciated. Original sheet - works good…
-
Index Match Multiple Sheets Showing NO MATCH
GTE PDI Offline has a winterization column that I am having our Master GTE Unit Tracker read off of. This was the formula I was using and it was working great. =INDEX({GTE - PDI Offline Winterization}, MATCH([Stock #]@row, {GTE - PDI Offline Stock#}, 0)) Jan 1 I moved all of 2022 information to it's own sheet but still…
-
Overall RAG Automation: Risk Register
Smartsheet Community: Has Anyone Automated RAG for The Overall Risk Register? For Example, The Risk Register has 6 Risk, 3 are Red, 2 Yellow, 1 Green Resulting in an Overall RAG Rating Yellow. Thanks
-
Two Form Solution - Multiple Lines in a Smartsheet & Special Conditioning
I was grateful to receive an email from Andree in relation to a two form solution for submitting one form with multiple lines of data; however, I have two additional questions. In Andree's file there is a toggle on the main form to generate the results from the two forms. How do I create this toggle? Additionally, the data…
-
Countif Formula not reporting Accurate number
Hello, I'm trying to report a metric on a dashboard and am using the following formula: =COUNTIF({Master Project Tracking Range 1}, ISBLANK(@cell) and the total is 29, however when I filter the grid the data is pulled from there are only 19 blank cells. I've also tried =COUNTIF({Master Project Tracking Range 1}, "") and…
-
Parent/Child row formula
What would be the formula to use for when you want to update the parent row with child row data? For example, if a subtask under the parent row is marked as 'In Progress,' I'd like for the parent row to be reflected as 'In Progress.' Thank you.