-
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.…
-
"Live" source template sheet
We have projects running with long and complex workflows and thousands of tasks - so we need to break these down into multiple sheets (dozens), and then use reports to extract data from tasklits to time-tracking and budget burndown. However - if we need to change the structure or components of the sheet in any way ( extra…
-
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?
-
How can I use allocation % properly to create accurate durations?
Hi there, My consulting company uses Smartsheet heavily and has been using Resource Management to track budgets, hours, fees, and time entries. Within that, I've encountered a challenge and I'm hoping that you all can help. Example: Work item in project Smartsheet takes 16 hours, but the duration of the work item is 21…
