-
Merge multiple columns into one?
Hello! I am trying to put together a form through which my staff can request the use of volunteers. To make this form as easy as possible, I've included a question about which department is requesting. Based on logic, that will take the requester to a dropdown with their most common volunteer requests. In other words,…
-
Need help creating a custom duration formula
Hi! I need help with a formula to automatically update the "duration" column each day as well as only count weekdays and not weekends. Is this possible? Here is some more information. There is a "date submitted" column. A "status" column with three options: Not started, In progress, and Complete. There is a "duration"…
-
Need help with Distinct Count with multiple filters please!
Hi All! I'm trying to figure out how to build a formula to track how many clients still have outstanding issues on a different sheet. I have a basic count of outstanding tasks. =COUNTIFS({Reference Sheet}, "Outstanding Task") When I tried to add Distinct to this, it understandably changed my total to 1.…
-
Only showing data applicable to the person logged in (WorkApps?)
Hi, I am new to using WorkApps. I am in the process of rolling out a global solution impacting ~1000 project managers. I want to keep them away from the main data sheet, limiting access. I think/ hope I can achieve a WorkApp solution just giving them the details they need to update on Project progress. Is there any way of…
-
Return Adjacent Column Value of a Filtered Item
Hello experts, I am trying to figure out how to display the Status of the Primary Column after the largest Data Point has been determined. The formula I am using under "Largest Data Point" is: =MAX(COLLECT([Data Point]2:[Data Point]7, [Primary Column]2:[Primary Column]7, [Primary Column]@row)) So this tells me the largest…
-
IF OR Formula with ISBLANK
Hi I'm after a formula that will check if [Date Modified] is more than 30 days from TODAY and / or if the [Current Position] is blank enter boolean to check the box in [Update Required]. This is the formula I have but, it doesn't like it. What am I doing wrong? Nested formulas are not my strong point! TIA Cheryl
-
RYG - Checkbox/Age Group
Hello, I am having an issue with figuring out how to create a formula for RYG and checkbox columns. I have previously set this formula to be based on 'open' and 'completed' requests. Since this has changed we now have 'open', 'pending', 'at risk', and 'completed' requests. The formula, in the beginning, was based on 'open'…
-
Task crossing seperate months - counting the days in each month
Hi, I have a sheet which in which we have tasks both starting and ending in the same month as well as some which start one month and end in the next. I am trying to calculate the number of days which fall in each month. Is there any way to do this? Thanks Derek
-
Formula Needed- Return date from week number
Hi All, I am in need of a formula that will return the date from a specific week number. We work off a unique week number calendar. Because of this, I haven't been successful using the week number formula. I hope to use 5.1.22 as week zero/launch date and have this date specified in my sheet summary. I also have a…
-
Is there a FILTER function in Smartsheet, which is equivalent of Filter function in excel ?
I want to find out the stack rank percentile (i.e. where the employee stands as top 10%, bottom 10% or middle 90%) of each employee in her department in a list of employees from different departments depending on what 'Stack Rank' has been assigned to that employee by her Department Head in that Department. For example,…
