Do you know how we can create a form where one of the filed is drowndown list to be chosen from the list stored in other sheet ?
I don't think this is possible at this time. You will have to pre-populate the column properties with the list and keep them in sync. Would be a great feature though! I suggest that you submit a product enhancement request.
Thanks, I have just submitted this request.
I cannot for the life of me figure out how to get the overdue which is in a date field in red text, counted on multiple sheets and only if its not complete, or not cancelled - everytime we try, it get 0 which is inaccurate =COUNTIFS({Exp_Status}, <>"Complete", {Exp_Due}, <TODAY())
Hi, I have an existing filter comprised of 6 predicates which all have to be true. I want to edit this filter to add a predicate (to make 7), but I only seem to be able to remove a predicate, not add one. Can anyone help please? Thanks, GAM
I have a smartsheet with data, I would like create a UI for other people where when they just type one of the specific data (such as name) and information about that row pops up without even opening the smartsheet. So it is easier and quicker to retrieve data.
