What am I doing wrong? I am linking cells from one sheet to another. When I do so I select two cells and then link them to two cells in another sheet. However, only the first cell has a link not the a…
Hi There, I am using my smartsheet to manage a production of furniture goods. I have set columns up for Start/ Finish/ Expected finish/ Duration/ and Delay to Expected finish. This will enable me to s…
We are new to smartsheet and looking for advice on the best templates to use to track schedules, and being able to track delays, etc. Would anyone be willing to share ideas or sheets that you have fou…
I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, …
Hi there, i'm trying to figure this out: I have sheet #1 with an email address field. When that field is updated, Smartsheet automatically updates sheet #2 email address field with the email entered i…
I am trying to average how many days a claim has been open for a certain technician. We signify the claim being open by having a certain column being blank... here is the current formula that I have: …
I have created a sheet summary and copied same format to other sheets. A number of fields in the sheet summary contain linked data from the actual sheet using cell linking. This includes dates and tex…
I am working on a template for my dashboard that would show an image of the project in the top right corner. Now this image will change for each project. The goals is to have some of the data for the …
Hello, I am working to create an automation off of the date modified field. This is to alert users if they have not updated a row in more than 4 days. Since the date modified field is not recognized a…
Greetings - I'm having an issue trying to flag duplicates from 2 separate columns in the same sheet. I have been able to flag duplicates in a single stand-alone column but trying to using the same for…