-
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!
-
Project Progress/Reporting
I am creating an simple method to help us determine project progress to report back to our customers. The idea is to group tasks into phases and then classify each project as being in a specific phase depending on which tasks have been complete. Once all tasks in a phase have been completed, the sheet will report back that…
-
How to add a formula within a form that auto populates based on values filled out in other fields?
I need to include a formula in a form that shows a percentage based on values that a user will input when filling out a form. I need to do this because other questions on the form will depend on the value of the formula. For example, My form has these two fields: Original Contract Amount & Change Order Amount I then need a…
