-
vlook up
Hi, I'd like assistance in creating a vlook up formula. So I would like the sheet to vlook up and find the date of birth and postcode from a different sheet when the name matches. See attached image of how the sheet where the vlook up needs to be added is set up. I have got the same columns and names set up in a different…
-
How to get the max value in a column based from distinct values in another column
Hi mates. Can you please help me to get the max value in a column based from distinct values in another column? For example is like this How to find the max value of "Car" based on the left table? Please kindly help me, this is urgent.
-
Managing and Reporting on Multiple Projects Effectively
I apologize for the length of my post, but I want to be thorough in describing what I would like to do and what I’ve already tried. I’ve also searched through help and the forums, and I either haven’t found a solution or am too hyperfocused on what I’m trying to do that I’ve missed it. I’m looking for a way to manage and…
-
IF Functions and Dates
Hi All, I am trying to use an IF function with dates. For example, IF a date is less than 15 days, return green, less than 30 days, return yellow and more than 30 days return red. When I tried typing this function in using the correct symbols and true/false values, I get an error message. I am creating a log of requests,…
-
Auto-Assign Contact based on Country
I am trying to create a formula that will auto-assign the [BG Check Phase Assigned to] contact list column with an individuals name based on what country is selected from the [Country - Site] drop-down field. So if the Country is one of: Austria Belgium - Brussels Belgium - Greenhill Belgium - Mechelen Bulgaria Croatia…
-
Request Tracker Form
Hello, I have a couple of questions. I am looking for the formula in the "estimated days to completion" column. It doesn't appear to be included (Screenshot 1). Also, how do I reset the request ID numbering to start at 0 again (Screenshot 2) ? I tried deleting the rows and that seemed to cause all sorts of problems. Thanks…
-
Backup tool for one user only?
I am using the backup tool provided through the below link with SmartSheet. The issue we are running into is that we do not need it to backup every single user (this is time consuming and bloats to over 3 gigs of data currently). We are looking to keep this more targeted if at all possible. Has anyone had any luck altering…
-
Formula assistance: adding 12 weeks to a date.
Hi, Can anyone please help me setting up a formula that add 12 weeks to a date. Say if in my main Smartsheet I have populated 10 different dates then I want my "stats" sheet to have a count if formula that adds 12 weeks to all the dates.
-
Does COUNTIFS work with only 2 conditions?
Ive been trying to add multiple conditions in to calculate some values for my Sheet Summary, but I cant seem to add more than 2 conditions. Each of them work individually & with 2 conditions, but when i add the third condition it always shows '0'. What am i doing wrong? The formula I'm using is: =COUNTIFS([Overall…
-
Counting no. of times a value is entered in a column
I'm using this formula and the answer comes up 0. I want to count the no. of times 0 and 1 appear in a column. =COUNTIFS([No. of mos. cash available]:[No. of mos. cash available], AND(CONTAINS("0", @cell), CONTAINS("1", @cell)))
