Hi, Very new to using SmartSheet. Can someone help me understand if I can pull information from a Sheet in certain rows only that do not have a unique identifier. I just want it based on the answer fr…
This is the formula I have =COUNTIFS({Overall Grade}, >=4.5, {Fleet}, "717", {Mod Helper}, "100") On the main sheet, there is a helper column which converts the module number to a set 3 digit number (…
Hey All, I submitted this product enhancement request through a feedback request a while back but I think this idea has a lot of merit and would really benefit the community as a whole. If you are lik…
Column in Main Sheet: Ultimately meaning there are T-X days until resolution action is needed (helper column). I have thrown the ranges that I am wanting to report in to another sheet, for calculating…
I have a list of tasks and a common start date for all tasks. Now, if there is a resource or an engineering dependency , then the subsequent tasks will have to start after the current task ends. I am …
Hi, I am trying to figure out a way to automatically get specific columns in one sheet, into another sheet I was originally looking at using a workflow to copy the rows over, but I only wanted to copy…
Help PLEASE!!! I am looking for a formula that will sum the total travel cost of resources, if selected, based on the qty of each resource and also the resource rate (from another data sheet). For thi…
I am building a safety event submission sheet and I wanted to add some metrics to a dashboard. If an event is submitted, that day is considered a "Red" day and if no events were submitted it is a "Gre…
Hi! I would like to make a form with the options pulled from another sheet. This is to prevent an incorrect project code being entered. The column drop-down options would need to be a the list of proj…
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Conta…
