-
Merged: Sheet property information?
This discussion has been merged.
-
Change "end date" based on status changes
When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies…
-
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…
-
One sheet creation to trigger the creation of a second sheet
Response to Pro Desk 07270893 session. I have a form set up that creates an entry into a sheet. I am looking for when the form creates the entry into the sheet, to trigger a 2nd sheet (different sheet) and attach the 2nd sheet link in the attachments of the original sheet entry.
