-
Auto-populate vacation time in production timeline
I am trying to see if there is a way to automatically blackout vacation time specific to a person, similar to the way holidays are able to be blacked out.
-
Cross Sheet Formula with One Criteria
Hello, I am creating Smartsheets for quality assurance testing. Sheet #1 will be the test scenarios and steps taken. The row will include a drop down menu to indicate if the step passed, failed, etc. I need a formula that if "Fail" is selected from the drop down menu, the step's ID # will automatically pull into Sheet #2…
-
CONTAINS with Trigger Search
Hi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device type that contains "Coin". This address will then be checked against the address column until…
-
Populating cells in a column with data from cells from a different column on the same row
Hi, I'm currently trying to build a column where if the cells are blank, they are populated with the data in a cell on the same row but obviously in a different column. This sheet is populated by form entries and I'm trying to fill this column without making its field on the form mandatory. Thanks.
-
Is it possible to count the number of entries in a column for the current work week, and quarter?
Is it possible to count the number of badge IDs in a column for the current work week, and a quarter? I need to track the progress of a weekly target that resets every Friday. Currently, I can not get the CWs (blue) to align this is my starting point for all of our contract workers. Here is one of my sheets created that we…
-
Include child rows in approval request
Hi all, I'm hoping that you can help me find an easy solution to an issue I'm facing. I publish two monthly newsletters (External and Internal editions in the screenshot below) and the first step of my prep work is to have my manager approve my proposed lineup for each edition. I'd like to send an approval request or…
-
Rich Formatting On "Summary Sheet"
I'm stuck! I am effectively trying to create a Sheet Summary report with conditional formatting, however, I understand that is not an available feature. Instead, I am trying to create a sheet (not a report) with formulas that pull from multiple sheets and can be formatted. I have 20-30 real estate development/construction…
-
IF Formula with Children
Hello Everyone, I am trying to figure out a formula that would show the children's status on the parent row. IF the children's "Status" column is "Completed" OR "Completed By Black Ops", the parent "Case Status" column should be "Completed", otherwise, "Pending" Thank you in advance.
-
Looking for most recent date
I have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet if the "Combined" column values match that on the first sheet and if "Most Recent" is checked in…
-
Populating a Dropdown List
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?