-
Digital Signature
Hi all, I've searched for this topic, but i could not find directly what i was looking for. Is there on Smartsheet any functionality for digital signature that doesn't require pairing our service with another software? All the solutions i saw were about using another software to do it, but those were from 2017. I am just…
-
CountIFs formula question
Hi, I am trying to count the amount of time a drop down is selected within a range of columns that is in a specific location (separate column with it's own values). My goal is to count how many times Location (A-C) have the value Properly demonstrated and Not Properly Demonstrated selected. This is currently the formula I…
-
How to attach notes to a line item
Hi, I need to attach notes to my line items. Setting a column as a Note Field is not practical, as I have too much informaiton than can fit on a short line. Using Comments is not practical, as I need to be able to easily access and edit the notes, not scroll thru a list of Comments. How to achieve this in Smartsheet? Thank…
-
Can I turn comma separated lists into multiple-choice dropdowns?
The title basically says it all. I have a column that was built in Excel, with multiple items separated by commas (no spaces) to make a string of about 1-5 items. We're moving our processes into Smartsheet, and I want this information to be formatted as a dropdown column with each item chosen as a separate entry.…
-
Can I use global update on a sheet template's form?
I would like to do a Global Update in Control Center on a sheet template's form. This will allow me to update the form on a specific sheet in 70+ projects very efficiently. My worry is that this functionality is not available and instead I will need to go into each project, find the specific sheet, and manually update the…
-
Booking calendar appts
has anyone created a booking calendar? this will allow users to select an available appts by showing the appts that are open. Similarly to how the calendarly app works
-
Merged: Sheet property information?
This discussion has been merged.
-
SmartSheet Merge of Cells - Need a good Workaround
We have a sheet that repeats information…in Excel we would Merge the Cells to give it a cleaner appearance. In Smartsheet, we understand we cannot merge cells. We are interested if anyone has found a creative workaround? Example attached shows RED boxes where we would like to merge cells. Any/all assistance is appreciated,…
-
How to use SQRT function?
Hi! I searched through the functions and see that there's no SQRT function in smart sheets and the cells don't allow you to use the ^ key. Has anyone had experience, or have any advice on what to do? I tried making a whole new column just to root the function and it returns #unparseable, along with this the (A1)^0.5…
-
Need help with formula on helper sheet to pull specific data from other sheet.
I have a sheet where employees submit information to me. I created a helper sheet because I want to see all of the employees who submitted requests 2 or more times in the current month. Is this possible to do?