-
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…
-
Link Data in a Smartsheet on a Specific Day and Make Static
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to create a new Smartsheet that links data from the %Complete metric on a given day, and make that data static in the new…
-
How can I automate a subtraction
Hey, How can I subtract a number from the total each time a row is added. I have an Inventory sheet that linked to another sheet. for example, in the picture below; how do I subtract a Number of Machine each time a row is added? Thanks in advance.
