-
How can I copy information to a new sheet to create a log?
I'm trying to see if there's a way to have data copied from a few specific columns to a new sheet. I'm hoping to create a log for IT issues as they occur on requests. The difficulty is setting some sort of trigger that will move the information over into a new row whenever a new issue is added. The other possibility, would…
-
Grouping info on reports
Hi all, I have 3 spreadsheets for which i want to report information from. All of them have common information/references (i.e. POW1234) but the name of the columns where that information is will be different from spreadsheet to spreadsheet. Is there a way to, on reports compile or group all the rows that have the same…
-
Create Summary Sheet
Hi, I have been unable to create a summary sheet which I think will work better with charts on the dashboard. I created this report but want to do the same thing in a metric sheet. I am lost as to how to accomplish this. Any advice?
-
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…