-
Columns Moving Automatically
Has anyone had any issues with column headers moving around the sheet automatically. I have multiple sheets referencing each other using vlookups to report back and also to use tools I have created. Therefore the location of certain columns are highly critical to my companies daily workflows. I have already confirmed that…
-
Cross Sheet Reference stopped working
We currently have a Pharmacy Site API reference sheet that is updated daily at 2am PT. Since its a complete rewrite, the sheet is deleted then generated every morning with the new updated site information. This master sheet is indexed across several hundred Smartsheet solutions within our company. I have a specific sheet…
-
How to automate or move cell values when a date is in the past week?
Here is a tracker of a 10-weeks look ahead of number of hours to spend in project from Monday-Friday which are highlighted in blue cells. The Start Week and End week changed if a date is based on current week. Which means 9-Jun-2024 will be the current week by next week , correct? The problem now is the no. of hours is…
-
Data mesh cell history
Hello! I would like to make a suggestion regarding cells that are populated via Data mesh. As of right now, when a cells gets populated via Data mesh and you click on View Cell History, you can see the name of the person who owns the Data mesh. However, you have no idea if the person manually input that information or if…
-
Is there a way to convert a large number of contact cells at once?
I have over 5000 rows in a sheet that has been exported from ServiceNow. Every row has a contact cell that is filled out with a raw name, no company email. Is there a way of converting every cell into the respective company email for that person at once? The manual method, typing their name and selecting the pop up, will…
-
How to write an if or formula with either or return?
I am trying to write a formula that says if the Department column says Pharmacology then return "Pharm" or If Department column says Biology then return "Bio" Thank you in advance. This is what I have that isn't working: =IF(OR(Department@row =Pharmacology, "Pharm",IF(Department@row =Biology, "Bio")))
-
Best Practice for Control Center managed links in project templates
When we developed our templates with the Smartsheet rep years ago, they mentioned it was important to keep certain 'metadata' in the second column, and that there should not be another column between the primary and second column. Below is an example of the navigation section and the summary section at the top of our WBS…
-
Allow linked cells to trigger workflows
Just as the title says. It's really frustrating when you want linked cells to trigger a workflow but you can't.
-
How to add if cell is not blank then...or if cell is blank then leave blank?
Thank you in advance. I have the formula working that I need which is this: =IF([PO Amount]@row > 100000, "Level 3", IF([PO Amount]@row > 50000, "Level 2", IF([PO Amount]@row <= 50000, "Level 1"))) But I need to add text that indicates if the cell is blank than leave blank or if it is not blank than the formula above. This…
-
Is there a way to create a search box?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
