-
Formula to check Child Row checkbox if Parent row contains "ABC Dept" (filtering by Department)
I have a "Master" project resource sheet with great grandparent rows for "Current Projects" and "Future Projects", Then grandparent rows for each "Project", parent rows for department and child rows for the individual resources per department. I'm trying to create a filter to filter resources by department across…
-
Smartsheet template with approval request
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, number and dates. I am quite sure this can be accommodated by the template. Can the template also cater for Approval requests?…
-
Send Weekly Request to Complete Survey
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 workflow set up so that an alert is sent to each team member every week at 2:00 pm on Fridays. In the Message, I included a…
-
Unhide row
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 need. On the other hand, you can't hide, and therefore unhide rows as such, the only thing I can think of is that I may have…
-
Alphabetize Filter Options
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, see a scrollable list of project managers - out of order - How can I alphabetize this list?
-
Auto Populate second sheet
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 when a new entry is added through the form on the main sheet, a column is updated on the second sheet reflecting the new…
-
Prevent a milestone from moving, regardless of predecessors? (flexible lag time)
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 predecessor (Finish-to-Start), it moves my milestone date! (Moves my milestone date earlier, to occur the day after my predecessor…
-
Formula to count fields that are not blank
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 contain dates so if any cells are blank it won't count the cell. This is the formula that works in Excel…
-
Filter not Working: Is not in the last (days)
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 have my archive set up and it always returns items that were submitted today (which most certainly does not meet my filter…
-
Trigger notifications based on dates previously input
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, test required, etc. The other (second) spreadsheet will be a record of materials booked in. Will it be possible that, by…