-
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…
-
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)))
-
IF statement for a check box helper column
I have a form that has a status of sick or returning. There are other columns but not needed for the formula (other than name). I want to add a helper checkbox and when someone submits a form for returning (they will have already submitted one for sick) the matching "sick" row and the new returning row will match the name…
-
Trying to count values based on variables
Hi there - first question ever! Also - not great at using the right language so sorry if it's a bit confusing! I am currently trying to use a formula to count if a certain condition is met in column a - and in column b - to count it. so for example Column A (Role) Manager Assistant Officer Column B (Off Work) Yes No Yes So…
-
Out of office Calendar
Hi, I would like to build a sheet to collect inputs from my team across the regions to share to the entire team the planned “out of office” period. These could be half day (morning or afternoon) or full day. I plan to use a FORM to manage the input entries but I’m looking for a way to display well the scheduled…
-
The Average Number of Monthly Projects
I want to be able to have a formula that pulls the average number of projects we complete monthly for our sheet summary. I have a date column for "Date Completed". Can anyone help with what the formula would look like?
-
Sequential Unique identifier for two types of records in a sheet
Hello Smartsheet community. I am in need of a solution that allows me to leverage an intake form to track Objectives and Key Results. I need to be able to sequentially generate unique ID's for each Objective and for each KR and I need this to not break with sorting. The reason is, I need to do lookups on the Unique…