-
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…
-
Join Collect formula that excludes the current row from the results
I'm trying to create a formula that creates a list of duplicates in my sheets, I've gotten this formula to work but it's showing the original row within the list of duplicates. I tried adding an auto number column and including a condition that the list shouldn't include the current row. However, the addition of this to…
-
Lock or Store Date/Value Solution without using Zapier
Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it…
-
Archive sheets and remove access to URL for users not directly shared to the sheet
I have a few sheets that have been created that I need to archive to only be accessible by a few people who are shared directly to the sheet (sheets are used for reference purposes but don't contain current info which now lives elsewhere). These sheets were previously shared to a larger audience, and a lot of them have…