-
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…
-
Cross reference error
Hi there I have created a cross reference with another sheet and named the ranges as well. It works fine for few days and then after few days it shows invalid ref error Again i have to re refere the ranges in the formula and it works fine for few days. Please help me and guide, what i have been doing wrong. Kind Regards…
-
Formatting numbers like in Excel
How to format numbers in cells to show thousands separator and two decimal places. I tried to search , could not find any thread about this. Someone please help. I am new to smartsheet.
-
Yielding blank cells
Hello, I'm using health circles to indicate progress. However, I want the circles (green, red, yellow, and gray) to show active stages in the process (complete, incomplete, in progress, on hold, respectively). I want phases that are not yet started, because the start date has not yet started or is not yet set, to remain…