-
WEEKNUMBER formula not returning correct result
When I use the formula for WEEKNUMBER, my results are being offset by 1 week between Sunday and Monday. Sunday, Sept. 12 = Week 36 (Correct) Monday, Sept 13 = Week 37 (Incorrect) I have checked my project settings, set my working days, etc., but I cannot figure out why this formula will not return the correct week number…
-
Find cell value with 99%
Hi, Is there a way to find and count every cell which equals 99%?
-
Using smartsheet to reserve an interview slot time
Greetings! I'm the HR manager at a company and I'd like to ask for advice on finding a way for candidates to be able to reserve interview slots on a calendar through Smartsheet. Our SB interviews a lot of people and since it's hard finding a time that works for everybody all the time we have set hours for when we do…
-
Last 30 days range
Hello, I have looked through the forums that are currently open and could not find a formula that would fit my current needs. I am using the following formula now: =COUNTIFS({Pre Trip Completed}, <3, {System}, "ITCMW", {JBO Type}, "Overhead", {Date}, IFERROR(MONTH(@cell), "") = 8) This formula is pulling data by month (8=…
-
Automatically write the number of task according to the hierarchy of tasks
Hello. Pls, help me. How I can automatically write the number of task in a column according to the hierarchy of tasks?
-
Autofill Assigned To with contents from first 2 cells
Hi all, I want to create a template which has a couple of rows at the top which then control what is set in the cells below - when the new sheet is created from the template Row 1 will be assigned to (example) Albert, Row 2 should be assigned to (example) Bertie. What i would then like to happen is have all the rows below…
-
How to count "Contact" cells with multiple contact per cell
There is a contact column where multiple contacts per cell are allowed. How can I count the total number of rows that contain a specific name? Is it possible to combine COUNTIFS & CONTAINS? =COUNTIFS({Responsible}, {Status}, "NEW", {Responsible}, CONTAINS("Dmitry Gorobets", {Responsible})) The formula returns 0, but the…
-
Formula to chose 1 value from the range, mentioned in one cell
There is a cell with number of activities, related to accountable people. Plese see screenshot #1 attached. This cell reffers to "Accoutable" column in other SmartSheet table. See screenshot #2. The problem is "Accontable" column in intitial sheet contains more then 1 Accontable person's names. Formula, I used:…
-
Assigna mail adress automaticly
Hi there ; İ would like to get your advices about below issue , i have a column that i enter names ( colum name "Responsible") , near responsible column there is one column too (colum name "mail adresses" ) , is it possible that when i enter person name , mail adress will be written automaticly , these people that i add to…
-
Continuous Date Function
Hi! I use the daily sheet that was built by Smartsheet as a template for 2021. I want mine to keep going through 2022. The formula in the template is: =$Date$1 - VALUE(YEARDAY($Date$1) - 366) How can I keep coping this down to go through 2022? I have tried just the normal grab and pull down but that doesn't work. Seems…