-
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…
-
Join, Collect functions
Hi All I am trying to retrieve results from several columns on a seperate sheet into 1 cell on another sheet. This formula works - =IF(INDEX({SUS Badge}, MATCH([Full Name]@row, {SM Name}, 0)) = "Not achieved", "SUS Core", " ") But as soon as I add more columns - =JOIN(
IF(INDEX({SUS Badge}, MATCH([Full Name]@row, {SM…
-
Wildcard workaround
Hi, Trying to get some counts for a report and have run into a bit of a road block. In excel, I would typical use a count formula and a wildcard. However, Smartsheet doesnt seem to have the capability. Below if my code: =COUNTIFS({Papers Range 2}, "*O'Malley*", {Papers Range 3}, "1 - Published") How would I edit this to…
-
Calculating a running tally of time
Greetings colleagues - I'm stuck and could use some help. I have a checklist that needs to calculate the Start and End time (hh:mm) given the first start time and duration in minutes for each step in my checklist. All of my columns are Text/Num. I read countless posts and got the Row@row-1 set up so a helper column will…
-
HELP! Column Formula working on some rows - not others
Hi! I'm stumped on this one. I am using a column formula to apply a date 21 days prior to the date in another column. Everything (formatting, etc) is the same on all the rows, but I keep getting "Invalid Value" errors on some rows and in other rows it works great. Does anyone have any ideas?? Formula: =DATE(YEAR([GT…
-
How to use LARGE function using criteria. AKA "How can I get the #1 risk based on criteria
I included all this information in the snippet but here is my issue. The issue is I cannot get a formula where the "Risk/Issue" column identifies whether it is a RISK or an ISSUE or an RISK BECOME ISSUE, and then give me the #1 item depending on that criteria, then the #2 item depending on that criteria, etc. My current…