-
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…
-
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?
-
Auto- fill information from another smartsheet
How can I make my smartsheet pull columns of information from another sheet? The data I want to have duplicated is entered first on a vendor intake sheet, the two columns I want to 'link' or duplicate are a unique name and contract number (in separate columns) and I want to have them pre-populate on a contract deliverables…
-
How to automatically generate a Date that's three weeks later than a given Date in another column?
I have a column named "Creation Date" (Date Type) and another one named "Response Due Date" (Date Type). The "Creation Date" is automatically recorded whenever a new row is added. How do i automatically set a date 3 weeks later in "Response Due Date" column. KEEP IN MIND PLEASE, that i already have 100 rows with manually…
-
How to write a formula if then formula with multiple conditions
The formula I am looking for is if a PO Amount is greater than 50,000 then return a circle but if it is greater than 100,000 return a square and if it is less than 50,000 return a triangle. I have tried =IF([PO Amount]@row <50,000, "triangle", IF[PO Amount]@row >50,000, circle, IF[PO Amount]@row >100,000, "square") this…
-
How do I write a formula that returns a circle if a PO value in another column is greater than $100
=IF(["PO Amount"] > $10, "Circle", ["PO Amount"] <$10, "Square")
