-
How to create a future date based on a date in another column?
Hi, I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days. Thanks! Keren
-
Creating different sheets based on one main sheet.
Hi everybody, I need to create separate sheets containing different information from one master sheet. But I also need to configure this in a way that if a new row is added to the master sheet, it will automatically be added in all other sheets that I created based on the master sheet. Any help is appreciated!
-
Date and month, linking cells
Hi there I'm linking cells from numerous sheets to one specific. Most of the cells are containing dates. When linking, I have realised that month and date have switched places. Not all dates/cells, but in some cases. See below example. Original work sheet: 03/06/19 Linking work sheet: 06/03/19 I've double checked the…
-
Notifications Not copying with sheets
Hi All, I have been having an issue since Friday when I save sheets as new, I receive an error that the sheet was copied but the notifications weren't. Is anyone else having this issue? I submitted a support request a couple days ago with no response. Thanks, Brooke
-
Linking sheets through dropdown box
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including workplans, professional development and reporting. On each sheet I would like to be able to ask the staff member to choose their…
-
Web form submitted child rows - how to sort them into place?
Good afternoon, I have a sheet where we are tracking time allocated to various projects. Each web-form submitted project is then given a parent/child relationship with the child row being the submitted info and the parent being the summary view of all the children by the same project name. However, when I try to sort new…
-
How to force a sheet to fully recalculate via the API
Hi there API Developer community, I wish to use the API to force a sheet to recalculate. Currently, we use a report that shows just the first row of every one of our 50 or so project sheets and then we manually copy a new value into a column on that report that we have put aside for the purpose. So, once a value like…
-
Left panel menu
I liked the tabs on top of the sheets. I could put them in whatever order works for me. I don't mind the "left panel menu" that we now have instead - but I DO NEED to put the list of sheets in the order that makes sense for me! Every time I need to open a different sheet, I have to scan up and down the list of 20 sheets,…
-
help with formula
Hello, I'm still quite new with sheets and I wonder someone can help me out with this formula I'm currently struggling with. What I want to do is to check/compare email addresses. The following works well when adding formula to a check-box type cell comparing whether the [Modified by] entry is the same like [Email] entry.…
-
Dynamic Publishing - is it possible?
Hello, We have been using Smartsheet for a while but mainly to assist with our project management tasks and I am pretty much a very basic user in terms of skill level. However, we have a new requirement and exploring to see if this is something that we can use Smartsheet as well. We are looking to move our gifts registry…