-
Masking a cell's default value and formula
In the sheet below columns C, E, and K are calculated based on values entered in columns H and I. The formulas are copied in rows throughout the sheet and return a default value of 01/01/40 before they are triggered. How can I mask/hide the default value before values are entered? The desired outcome should be as theโฆ
-
Form - Restrict input of a past date
Hi, I am re-opening this question to know if any updates have been made since? The question is related to the Smartsheet Form, on having an option to restrict a sender from being able to enter a past date in a form. Related discussion open a few years ago in this question 'Web Form - Disallow Past Dates?'. Thanks, Manuel
-
Help w/reducing the # of multiple date options
Is there a way to create a list and then an intake form of 10 dates available for selection - so when person X picks a date then person Y will only see the remaining dates when they go to the intake form? Looking to have the form populate their selections on the sheet but only show the people going to the intake form laterโฆ
-
Populating a dropdown based of the entry in another dropdown
Apologies if this has been asked and I just cant find it. I'm new to Smartsheet after spending several years working with Access. I would like to have a dropdown auto-populate based off of the selection in another dropdown. Each selection in the department dropdown will have multiple "areas" within them. So if I selectedโฆ
-
Unparseable and then need to scale up IF statement
I have the following - =IF(OR[Does pipe size match drainage drawing?]@row="",[Does pipe material match drainage drawing?]@row=""),"Awaiting assessment","Test") This is imparseable - is this the blank check bit - ""? I have noticed too that I would like to check for a 'No' in either of the cells. A 'No' would replace theโฆ
-
COUNTIFS Formula For Total Number Of Requests Per Month Assigned To Contacts
Hello, I am trying to troubleshoot a formula to achieve the following outcome. Outcome: Count the TOTAL number of rows in which the [Request Date] column is March (3) AND the [Requestor] column is any of the following contacts: Jesper Poulsen Libby Martinotti Michelle Wisbey Annel Ayala Anita Miazga Amanda Ayre Alexโฆ
-
averageif from another sheet
Hi everyone, I have a sheet that is populated from a form. There are several departments listed, and more often than not a department is listed more than once. Within that sheet I have a column listing the response time in days. The response time in days is calculated based on the information within that row. I haveโฆ
-
How do I keep pivot tables up to date with most recent numbers?
How often to pivot tables update? Will they always have the most updated numbers? We have multiple different trackers/sheets feeding into the master sheet which we track different metrics on all sheets.
-
COUNTIFS Formula not working when I add an ISBLANK statement
I have a COUNTIF formula that I can't get to work once I add an ISBLANK statement. This is the fomula that works: =COUNTIFS({Payment Type}, =$Status@row, {Case Date}, MONTH(@cell) = 8, {Case Date}, YEAR(@cell) = 2020, {Status}, ="Completed") When I try to account for rows where the Payment Type is blank, I tried thisโฆ
-
Autofill Cell When Another Cell Has Info Typed
Hi all, I have a worksheet where I am trying to find some solution/action for the below. I have a project registry sheet that I am trying to find a solution to autofill certains cells. There is a column for Customer Name, Customer Email, Customer Contact Number. If I type in the Customers Name, how can the correspondingโฆ