Hello, We will need to create multiple number of sheets periodically and thinking of creating them from a Template. The sheets will be quite basic/plain - mainly contain free text, drop down list, num…
I am interested in sending each of my team members a weekly Temperature Check survey. I created a new sheet to collect their responses, and a form with the questions. I believe i have an automated wor…
I need to retrieve a row in a master smartsheet. I can see that row in a report output, but cannot see it in the source sheet. In the master sheet row number jumps from 266 to 268 and it's 267 that I …
In one of my sheets, I can create a filter for the field "Project Manager" In the field(s) Show columns that match...if I click the dropdown arrow to give me the options for selection, I do, in fact, …
Hi, I have a main sheet with a form. As you know, every time a user submits a form, a new row appears. I was wondering if there is any way to have a separate sheet that connects to the main sheet so w…
I have a milestone date in my timeline (0 day duration). I would like to link it to a predecessor that is currently scheduled to finish a few days before the milestone, however, when I add the predece…
I am just getting familiar with smartsheets and am having a problem convert a spreadsheet that contains a formula that I really need. This formula currently works well in Excel to count cells that con…
Hello, I'm drawing a blank on why this filter is not working correctly. I process the archive of the data in this log and will archive every week the items that are 21 days or older. This is how I hav…
Hi all, Trying to build 2 spreadsheets that need to communicate with each other at this level: One of them (first) will have the raw material code, name, supplier, last date of testing, risk rating, t…
Hello, I am trying to creating a PTO form but we have users that work weekends. In Excel, there is a formula, NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays]), that allows to shift what …