-
Obtain Most Recent Value based on date of within Month
Hello, I am trying to obtain the most recent membership entered for the month, where the value doesn't matter if largest. The formula will be used to calculate the most recent membership of the month, for the calendar year from the Report Date. I was able to use =MAX(COLLECT({Membership}, {Month}, "January")) but comes out…
-
How do I auto populate a date column when another column changes state?
When Status1 Changes to Closed I would like to auto populate the date column.
-
Percentage complete based on Y or N for six categories.
Hello I am trying to develop a formula that would provide percentage complete triggering on Y for each category. So, in short, if one Y is seen, display 18, if two Y's are seen, display 36, if three Y's are seen, display 54, if four Y's are seen, display 72, if five Y's are seen, display 90, and if six Y's are seen,…
-
Formula to pull data from another sheet
Hi there! I am hoping someone might have some suggestions or ideas on the best way to connect two worksheets in smartsheet. On this project, there is a Smartsheet A which has a list of priority clients that we work closely with and tracks our date of last communication with the client so we can follow up as needed. We also…
-
Cross sheet column subtraction
I have two sheets where I am tracking inventory, one sheet contains data for material available, and the other for material used, given that not everyone has access to all sheets and I want to create a report where I can display the material available ( basically the difference), Is there a way to do a cross sheet column…
-
Formula Assistance
I am attempting to do the following: If status is Complete or N/A = Green If start date is within 5 days or past due and status is not Complete or N/A = Red If start date is more than 5 days and status is not Complete or N/A = Yellow I have the following formula, but no luck. Any help is greatly appreciated.…
-
How to count how many interviews in the current week?
I am currently trying to track how many interviews are scheduled in the current week per fleet type? The formula I have is counting 7 days from today but isn't including the current day. =COUNTIFS([Interview Date]:[Interview Date], @cell = TODAY(7), [Interview Date]:[Interview Date], @cell > TODAY(), Fleet:Fleet, "A220")
-
Formula help
I want a dropdown list to populate choices from another dropdown list. So If "Wonder" is selected in the first dropdown, I want "al.wonder" to be selected from the other list. If "Wonder" and "Organize" are both selected, I want "al.wonder" to be selected also "al.organize" to be selected as well. =IF([WW Label(s)]@row =…
-
How to match and automate dates?
If I have two tasks and want the due date from one to trigger and match a start date from the next what do I do? For example: Task 1 has a start date of 8/20/23 and a due date of 8/29/23, when the due date is put in or changed I want the start date of Task 2 to match (also be 8/29/23). I have tried some =IF functions and…
-
If Or Formula Help
My formula is working in Excel, but not in Smartsheet. I am still fairly new to smartsheet so any help would be appreciated. Basically its looking at the GLAcct column and find certain values and creating key terms for those values. Ex: If GLAcct = 710111 or 710121, then show Key Salary.