-
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?
-
Crossing multiple data bases with a Partial Text/Number match
Hello all! This is my first question. I am building a tracker called "My Project Tracker" that takes information from multiple "master sheets" built by different teams with different purposes. See screenshot for example. "My Project Tracker" has the "Project ID" as user input, then it populates the "Project Name" using the…
-
Track inventory movement in multiple warehouse locations
Hi, We would like to track inventory movement between multiple warehouse locations, there is no need to track stock value/sales, just need to track inventory movement between locations and the inventory balance Warehouse: Warehouse A, Warehouse B Item: Item A, Item B Current Stock: - Warehouse A, Item A: 15 - Warehouse A,…
-
Formula to match two column inputs within one row in two separate Smartsheet's.
Roster Smartsheet: Course Email Eval Completed Class1 Joe@email.com =formula here Class1 Jane@email.com =formula here Class2 Joe@email.com =formula here Evaluation Smartsheet: Course Email Class1 Joe@email.com Class1 Jane@email.com Class2 Joe@email.com Formula that doesn't work:…
