-
Archiving Design Pattern in Smartsheet
Hello, We currently have a very large Smartsheet we use to collaborate with external business partners. I have created workflows to add rows each week, and our cross-functional teams complete tasks related to each of these rows over a period of weeks. We are struggling to find the best way to declutter this sheet once all…
-
Changing WEEKNUM formula to pull on Sunday's instead of Monday's?
Hello, I have a sheet that acts as a "day tracker." Each row is a new date that tracks specific data in each column. I have a "Week Number" column attached to the "date" column, however the week number populated does not match the week number shown in Outlook calendar and Excel. I think this is because Smartsheets starts…
-
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…
