-
Validations/checks before changing the status of a row
Hello, First of all thanks in advance for support. I have a question, which i think is basic.... but i haven't find the way to solve it. I have a sheet with a status column, then i have 2 columns for KPI values: Status, KPI1, KPI2, start date, end date, etc.... I want to "not allow" to complete the task if the columns with…
-
How do you create a contact list based on 2 seperate sheets using a Vlookup.
Hello, Looking for some assistance with an issue we are having populating contact lists based on 2 separate sheets using a vlookup. To summarize the attachment, we have a sheet with a list of account owners and their email addresses (Client Services Listing) that is feeding into another sheet (CSLS Teams by Account) which…
-
Contents of a Dropdown Multi Select Column
Hi All I need help in using the contents of a Dropdown Multi Select Column. The column has the following options A B C I want to use the actual content say AB to lookup another Smartsheet for a price for that selection. I am sorry if there is an obvious answer as I can’t find it. Thanks AV
-
Counting number of new rows using Created (Date) and resetting each week
Has anyone posted a formula to use that counts the number of new rows added to a sheet based on the system generated create date? I want to do this and have it reset the count each week, perferrably each Monday. I want to: "Look in the Created (Date) column of Sheet 1 and count if the date [that this row was added] is…
-
Automatically Populate Monday before Existing Date in Sheet
Hi all, I've seen similar requests on these forums but unfortunately I have not yet been able to make this work. I have a project schedule with Start Date and End Date columns. My leadership would like to see two associated columns that show the Monday before the Start Date and End Date to help with planning - so they can…
-
Intake Forms: Dynamic/conditional fields or hidden links?
Hi! I have not found this topic discussed yet. We'd like to do a couple of things with our intake forms. 1. Make the intake fields conditional. Some surveys are set up so that what you chose in field A. will affect what you see for the fields following it. Like "What pet do you have?" If you choose "Cat" the next field…
-
Conditional links on forms
Hi, New to Smartsheet, is it possible to link fields on a form based on conditions i.e: - If user selects 'Production' from the field 'Employment Department' then mandatory that must select a 'Production Shift' (i.e. one of following Green,Purple,Red,Blue,Yellow) - Else if 'Employment Department' ≠ 'Production' then…
-
Creating custom "enterprise managed metadata" column types for use in multiple sheets?
Hi there, Is there a way to create a new custom column type? For example, I'd like to create a column type "Department" which would be a drop-down that would be populated with a managed list of official department names. Ideally, this list of departments would be managed in one location, and then if any department names…
-
Index/Match with multiple criteria - returning a date
Hi, I am trying to return a date from one sheet to another based on 2 criteria that must match. I have columns COUNTRY, PROJECT TYPE and DATE on both sheets and want to return the Date from the source sheet onto the second sheet based on matching criteria Country and Project type. Is there a way to do that? Been looking…
-
report: take over colors in grid view of a project
Hello, her's my build. I have a project file (file 1) with all details of different project but always with the same structure with different colors. Out of that I created a second PM file (file 2) with links to that main Project file (file 1). --> Until now all fine thanks to the "link from other cell of sheet" this has…
