-
Can I erase a reference name and reuse the reference name for another range?
Can I erase a reference name and reuse the reference name for another range? It looks like once I use a reference name and mark the range, I can't erase the name and reuse the reference name for another range? it will indicate the name already use on this sheet even I deleted this reference name? Is there a search function…
-
IF formula from multiple cell information
I've been tasked to show the approval status of a row. Due to how I created the automation, depending on the level of an award (same sheet as referred to recently) the Manager signer may show status in 1 of 3 different columns. I want to do the colored circles at the beginning of the row. Would do gray if the column is…
-
Drop Downs
I'm using multiple dropdown columns on my smartsheet, most work, but a couple don't. When I try to click on the dropdown, nothing happens. Not sure why?
-
How do I copy a HWO to different Smartsheets once a checkbox is checked?
Hi all, I am looking to build out functionality that copies a HWO to multiple Smartsheets once a checkbox is checked. Is there a way to do this without cell linking or copying the full row? Thanks, Jenn
-
How to change formula for more then one criteria
So this formula works for me. I am trying to add another criteria though and cant figure it out. =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Stained") And it works but i want it to add the "stained" and "staining in progress" in the same column. how to i rewrite the formula in order for it…
-
Conditional Formatting not working as expected.
Hi, Excel: 2016 Version. I am creating conditional formatting dynamically from VBA with the below code every time when I opened my excel. The rules are getting created, but they are not highlighting the max and min value in a row (conditional formatting 3 and 4). I am so confused, anything I am changing in this code is…
-
Functional Requirements in Smartsheet
Hello, Our project team recently transitioned to Smartsheet. I am currently deciding how we will develop Functional Requirements (e.g. Excel, Smartsheet, Word, One Note, etc.) and eventually test cases. Is there anyone using Smartsheet in this capacity who would be willing to share their experience (pros/cons) and template…
-
Automation 'Copy to another sheet' doesn't work
I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1. I've tried a couple of times and non of my rows are copied. To test it, I added to the same automation rule to not only copy my rows, but also send me a notification when this field…
-
Creat formula to evaluate date difference in working days
Hi All I'm looking for inspiration on creating a formula on separate sheet looking at data and dates from another. For this example, I have left on one sheet to demonstrate. I essentially have to complete all my projects 10 working days before Bom S Date starts and if not I need to flag up the QTY of projects and which…
-
Baffled......Circular / Blocked Reference (Vlookup)
This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but I don't understand why my sheets work perfectly for periods of time, and then start…
