-
Formula help
Hello, I used the below formula to return the total dollar amount to the main budget actuals sheet if the two Spend Category columns matched on the two different sheets. The issue is it only returns one of the dollar amounts instead of totaling all the money under the same spend code. How do I fix this formula to add the…
-
How do you limit items in a dropdown menu field based on the selection of another?
We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…
-
Data Over Time Report/Dashboard
Hi. I'm currently developing a dashboard to analyze metrics derived from support ticket submissions. I've been asked to provide insights into peak ticket hours, and I need assistance in generating the corresponding report/chart. Is it possible to use a "created" column from one sheet to generate a chart highlighting the…
-
How do I pull in a pay rate from another sheet when the identifier is on the sheet multiple times
Trying to Index/Match - Help! I need to pull the 'Total Base Pay - Amount' from another sheet into my current sheet by using employee ID as the match identifier, however there are 3 of the same employee ID on my current sheet. I am guessing since there are 3 of the same employee id's on my first sheet, it's confusing…
-
Cell Links through Formula
It would be great to be able to link to a table and row through a formula.
-
Clinical Trial Identification Tool
I created a form where providers can enter medical history to determine if a patient may be potentially eligible for a clinical trial. The sheet containing the form submissions has columns with cross-sheet formulas that match the patient's history to clinical trial eligibility criteria listed in another sheet. This is…
-
How to exclude weekends while using formulas
I am very new to smartsheets and have just been playing with it and need guidance. I am trying to keep it as basic as possible. Essentially we are trying to backwards plan from our "due date" of when to begin our parts. i have it where you manually plug in a "shop time" and manually plug in a "outside lead time" have a…
-
Formula to create link to filtered report using data from originating sheet as the "filter"?
I'm trying to create a master sheet that will be used as an onboarding checklist for new sales orders. There is quite a bit of leg work to do prior to the job starting and we need to track the steps and whether they are complete or not. I was thinking I could have the master sheet contain all of the check lists with a…
-
Populating a drop down from data in another sheet
Hello, I am in need of some assistance please! I am a developer and have been tasked with importing employee data into Smartsheet through the API. I have successfully built a C# service that pushes data into a sheet in smartsheet, my problem is they want to be able to auto populate a different secondary sheet (destination…
-
Need assistance writing a formula w/ Red, Yellow, Green
Column reference is [Open Days]@row If the number of open days is =< 7, I would like it to show the Green symbol, if between 8 and 29, yellow, and >= 30, red. Thanks!