-
Count and Concatenate Text
Count the total number of checked boxes in the children rows of [Completed] and compare that number with the total number of checkboxes using concatenated text. Your answer should look like this: "Total Completed: _ of _"
-
Links connecting one sheet to another are not working - how can I resolve this?
Links between sheets are not working. I've seen status updates on this from people in the past, but am not sure if this is an ongoing issue or if it has been resolved. If I need to submit a ticket to SmartSheet, please advise or advise how I might be able to fix this myself. Thanks!
-
Changing the default Timeline Display for Gantt Charts?
Hi there, Is it possible to change the default Timeline Display options for Gantt Charts (whether in Sheets or Reports, or ideally differently for each) such that when a new user views them for the first time they see the settings that the author intended? Right now, if I set these options for my own view of Gantt Charts…
-
COUNTIFS+CONTAINS
I get the message UNPARASABLE, what am I doing wrong? I want to count the non blank fields in rage 1, when in range 4 I have a certain value AND is the range 7 = OPEN value. =COUNTIFS({Final RISK/ NON CONFORMITIES GROEP AERTSSE Range 1};<>"";[{Final RISK/ NON CONFORMITIES GROEP AERTSSE Range 4};…
-
Pulling Column Info Based on Column Containing Data in Separate Sheet
I am trying to figure out how to pull in the Name, County and Status from a master list onto a new sheet based on the master's Status column containing data. I am wanting to do this so that we are not overlooking anyone. I have been trying to figure it out and have seen that I probably need to use the INDEX and COLLECT…
-
How to use index/match on multiselect dropdown list?
I am working on launching a global hiring form that uses this formula: =IFERROR(IF(Country@row = INDEX({Approved Seats Country}, MATCH([Unique Seat Code]@row, {Approved Seats Unique Seat Code}, 0)), 0, 1), 2) Basically this formula returns the number "1" by searching for the name of the country in the source sheet…
-
Time Indication and DATEONLY function
Hello, I have a few questions below regarding Smartsheet: We're utilizing Smartsheet to track start time and end time in a 24-hour clock to count the duration of some of the tasks we complete. How can I remove the time in "Created", I would only like to have the date. (photo 2) Question 1 Explanation below: I've noticed…
-
Help: formula won’t apply to a new template
hello, when a new templete is submitted, my formula won’t apply to the new row. Other columns will apply the formula, however “End Time Parse Left” won’t. How can this be resolved? please see photo below:
-
VLOOKUP on the if false of another VLOOKUP
I have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID" and return the "User" If they exist in one of the 5 reference sheets. This is my current…
-
SUMIF with cross sheet referencing
Hello all, I created a sumif formula that would reference another sheet. Copied below is my formula but it always results as "incorrect argument". I believe the problem is in the sum range (bolded in formula). Can someone please assist? Thank you, =SUMIF({SIS Quarter 1 Range 1}, [Column15]48, {SIS Quarter 1 Range 2})
