-
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)))
-
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…
-
Is there a way to email someone from a report?
Hi all, I have a published report and my leadership would like there to be a way to 'click on the contact' in the report to be able to send them an email. I'm pretty sure this can't be done in Smartsheet but I thought I'd consult the "brain trust" here ... We were thinking of trying to create a hyperlink with an email in…
-
Shared sheet to a user who just upgraded to Windows 10
This might be unrelated to the Windows 10 update, but it happened at the same time. In Chrome, she can no longer see some of the drop downs on a sheet that has been shared to her for quite some time. We have tested other sheets and she can see drop downs in them. The sheet is shared to her as an Editor. Any advice?