-
Is there a formula for one sheet to recognize data from other sheets?
Apologies in advance because I'm not entirely certain how to ask what I am trying to ask. We use Smartsheet as part of our transfer course evaluation workflow at a four-year institution. We are having to change some things in our workflow, and in setting up new sheets, I am struggling to find out if I can automate a…
-
Count for multiple values in a range
Hello, I'm having some difficulty setting up a countif formula for my sheet. I have a long list of barcodes as a range, and I'm trying to count how many times specific barcodes show up in the list. I currently have it set up to count for two barcodes each in separate columns. =IFERROR(IF(ISBLANK(Barcode@row ), "",…
-
Invalid Data Type or Invalid Column Value on Helper column
I'm trying to create a helper column to evaluate multiple drop down column values. This one is to return a value if the tested columns have a specific value. (Once I get this one working I'll be adding a bunch more but, alas, ran into this issue out of the chute.) For simplicity here, I've trimmed down my formula to only…
-
Multiple IF formula over 2 columns
So I have a sheet with 2 columns that have numbers, text or blank. I want a 3rd column to do this, "If column 1 is blank, display A. If column 2 is blank, display B. If both columns 1 and 2 are blank, display C" How would I write a formula to make that happen?
-
Attempting to create a formula to find items assigned to a contact from a drop down.
I hope my title makes sense. I work in a veterinary Setting, I am working to make some metrics for a sheet dashboard and I am trying to get a cell formula to show me how many of a category is assigned to a person. I have been able to figure out the totals per category in my sheet but now I want to be able to see it at the…
-
Timeline
I took the action plan attached my coworker gave me and worked on building a timeline chart. After a lot of research and testing, I learned that Smartsheet doesn’t currently support this kind of detailed Gantt-style visualization with actual dates on the X-axis, mainly due to limitations like too much data and lack of…
-
Determine the "priority" based on alphanumeric values in other columns
I am collecting priorities from various teams, via a dropdown with L, M, H values. How can I determine a "global" priority for each item, which would be the "highest" value selected between the teams? For example, if 2 teams have M and 1 has H then the global would be H. I could create helper columns that assign a value…
-
Create a sheet summary, which counts RAID items and their statuses from another sheet
Hi there, I have a RAID log called "Work Allocation RAID Log" and I would like to create a Summary Sheet so I can see all the types and counts based on status - please see below Type (primary): Action Decision Dependency Issue Risk - with their statuses (columns): Not started In progress On hold Completed Cancelled This is…
-
Form Issue with reloading/submitting after submission?
I have a form that submits to a grid that has been giving me sporadic results for the staff who use it to submit data. They can submit a form and sometimes the form will grey out on the browser or it will submit, but to me doesn't look like it actually reloads and leaves the user at the bottom of the form. The grid only…
-
Using HAS/CONTAINS functions with multiple choices
Hi there! This is my first time posting a question so sorry if I end up doing this wrong!! We run events across the UK and I have a sheet set up for each event site capturing data about the events, from day/date to type of event and breakdown of the number of people who attended. We've now started capturing any 'additional…