-
Dynamic View Predetermined Fields
I have a form that is completed by 16 different entities for 57 unique roles, filling a master sheet. I want to utilize the Dynamic View function, but also have prefilled fields and use a MATCH function from the master sheet to the dynamic view to match the input to the unique roles. The purpose is that there are a finite…
-
Multiselect Dashboard Widget HELP!
Hello! I am attempting to create a dashboard widget that shows me how much budget we are spending in each segment, and in what category. The source sheet contains these columns… "Budget" - text/number column "Category" - dropdown list (restricted to list values only) "Segment" - dropdown list (allows multiple values per…
-
Calculating net hours
I've found Paul Newcome's mega post on calculating hours and from that have successfully created the total number of hours worked. But I am trying to have it calculate net hours worked after taking away any unpaid break. Breaks will be 30 mins or 60 mins. I've seen other posts from people asking about it but haven't seen…
-
Raffle Type System in a Smartsheet Form
I am looking at trying to build a multi-select option raffle form. Lets say a form user has 5 options or "tickets" they can put into a bucket of goods for a raffle. I would like for the user to put in any combination of entering tickets per good that they can with the five tickets they have. I will put in a picture of what…
-
INDEX - Collect question
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…
-
Match Function to Return Required Digits
Hi Smartsheet Community! I am running into a problem and need some help with a Row ID formula using the match function. I have a project plan that is generating a unique Row ID, using a combination of an Auto ID Column Type (Row ID), the Client & Project Code, and a match formula to return the actual position of the row in…
-
mailto: Function in Sheet Cells
Imagine the following situation: you’re working within a worksheet and want to add a hyperlink to a cell, you can reference a URL or another Smartsheet file. But I’d like to reference to an e-mail address. E.g. we got our suppliers names in this cell, and want to write them as fast as possible a message. And by just…
-
Formula Index Match inconsistencies
Hello, I have been using an Index match formula, however it doesn't always pull back the correct match or provides a no match however when validating the data, it is there. Is there a better formula to use? Here is what my current formula is in the cell: =INDEX(reference sheet column),MATCH(@row in sheet,(reference sheet…
-
Seeking automation for Monthly Dashboard with separate Month Rows
Hi all - i am building a monthly dashboard with separate columns for each month's status, key takeaways, and next steps. I am wanting to build an automation that says for example: 'your {{current month}} status update is due, your last {{last month}} update was {{status color}}. Please be sure to indicate your key…
-
Pulling from 2 different sheets into one sheet
I am trying to pull project phases from one Smartsheet and project checklist items from another sheet into one sheet. I would like the information from both sheets to be on the same line in the destination sheet. (Report puts them on two lines) Below is my current formula and I received the error #Incorrect Argument Set