-
Auto Generate New Rows
Is there a way for a master sheet to be automatically populated by project sheets? What I mean by this is that I have them linked currently but if I were to add a row to the project sheet would it add the new row into the master sheet?
-
More functionality for for rules
The rules feature is nice but it is very limited and only allows to change things from different fonts, colors, strikeouts, etc. I would like a rule that allowed more detailed changes. For example, if column a says completed, changed column L to 100%. There are many different scenarios. We are unable to use the…
-
Could I refer a cell as part of the sheet name in functions?
I have a column with different carriers such as "AT&T" and "Verizon". And in the following column is a complicated nested functions, and part of it is doing search depending on the carrier name. For example, for the row "AT&T", I want search in the sheet named "ABC AT&T". For "Verizon", I want to search in the sheet named…
-
Send Row to another sheet (not via email)
I have multiple sheets with similar columns, and I'd like to be able to send rows between sheets easily. I know I can just cut and paste, but is it possible to make a button or other similar automation that moves the row from one sheet to another? The Send Row function looks close, but I can only find documentation on how…
-
If this then that
Does Smartsheet have the ability to move rows to a new sheet based on a condition being completed? An example would be if you have multiple projects (rows) on one sheet and want them to be moved to a new sheet when the status is changed to complete. Is that possible?
-
Common Picklist
Is there a way to define a picklist with values and then leverage that sinle picklist on more than one sheet?
-
Help getting Index/Match to find search value (number) in a cell with multiple values (numbers)
I have a sheet with the following formula in a column titled "Status": =IF(ISBLANK([PO#]1), "Processing", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range}, 0)) = "Loaded", "OTR", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range}, 0)) = "available load", "Logistics Dept", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range},…
-
Cross sheet formula/reference
Hi everyone, This may be a basic answer, but I am trying to build a dashboard for my company. I have 6 reference sheets that I want to filter into 1 large sheet (the dashboard). The dashboard is an accumulation of weekly data that the 6 sheets feed into. Each sheet has a different employee inputting different data. So, If…
-
Need help to upload new data from Excel to existing sheet
I have an Excel sheet that I pull data into from another system and then run a macro to organize it the same everytime. Is there a way to simply upload that new data over an existing sheet so I can use the new data to refresh/update a dashboard connected to that existing sheet?
-
Cell Linking
I have watched many videos but cannot seem to master the cell linking between sheets. I've tried multiple ways but never receive the results I'm looking for. I have a project on a sheet Named Eblasts and it has subcategories of Months of Year and then Tasks subcategorized under that. I would like to link the whole Eblast…
