-
Need help with RYG status formula.
Hi, I am using this formula currently to change a harvey ball based on dates. It is currently working, but I am modifying my sheet to include rows that I want to ignore for now, meaning that some date fields will be blank. I would like for the formula to return no harvey ball color when there are no dates in the cells to…
-
Check off completed if items collected, with different number of items needed to be collected.
Hi, I'm trying to make a list of people and items I need to collect for them. Sometimes I need to collect 1 item, sometimes 2 or 3. The last column I want to write a formula that will check the box if everything is collected for that person. Since every situation is different and I need to collect a different number of…
-
How do I create a formula to activate a flag if a column has not been changed?
I want to be able to send an automatic update request when people fail to add updates to a text column (Called Updates). Currently, this doesn't seem possible. But I thought of a workaround that may work if someone could point me in the direction of writing a formula. I thought of having a flag column that will go up if…
-
Date Range formula format
I'm trying to figure out a way to get the number of rows that have a date within a certain range. An example would be if I have a column with dates ranging from January 1 2020 to August 1 2020, how many of those dates fall in the month of January? Is this possible?
-
Problem with 'workday' formula
I can't seem to get the following formula to work in my smartsheet - it is referencing a column with dates in it: =Workday([Due Date]76,5) What am I doing wrong? When I type it in, it just treats the syntax as text. Thanks!
-
Calculating task % Complete based on todays date
Is there a formula available to calculate % complete a task should be completed, based on todays date? Thanks
-
Formula in a date column
I am trying to use the vlookup formula into the scheduled date column that also has dependency on predecessors. When inserting the formula into that column, the formula does not override that dependency. Is there a workaround to this?
-
How to make multi-select selections be clickable links (in a report or dashboard)
Hi there, Is it possible to add hyperlinks to each option in a multi-select column? For me this is less important in a Sheet than in a Report (or Dashboard), but I presume this would need to be set up in a Sheet for it to flow to a Report or Dashboard. To elaborate, I'd like a Report to have each selected item in a…
-
How do I link 2 sheets for calculating time off (Vacation Day or Sick Day)?
This sheet is the results sheet. This sheet is the information used sheet.
-
How do I create a summary page or report from a Financial Donor List?
Hello, I have a sheet that tracks donations as they are received; name, email, and amount of the donation. Some are one time donors, others are repeat donors, and I would like to create a summary page that lists each individual donor and the total amount they have donated. Also, is there a way for a new donor to…