-
How to Create Formula to return Fiscal Week
I have 1 column with Start Date for Fiscal year & week 2nd column is end date for fiscal year & week I want it to return 3rd column where i have FYYRWK This is all housed in a separate smartsheet. Ive tried a few different articles on smartsheet, but cant seem to get one where i want it to be = or Greater than & less thanโฆ
-
Can someone help correct this formula
I have been trying to calculate a due date based on the date an issue was received and the priority.I have entered the following: =WORKDAY(IF([Priority]10, "red", [Date Received]10, 0), IF([Priority]10, "Yellow", [Date Received]10, 2), IF([Priority]10, "Green", [Date Received]10, 4), IF([Priority]10, "blue", [Dateโฆ
-
Can anyone help with a formula to count distinct entries that are not "N/A"?
So far I have been able to count distinct but have not been successful in excluding the "N/A" value. Any help is greatly appreciated.
-
% Issues on Chart
I have a pie chart that equals 101% instead of 100%. Smartsheet is rounding all of my data up to cause this issue. How can I keep it from doing this?
-
SUMIF of one column, but need to exclude in the formula if another column = a specific value.
I am trying to get the sum of a specific column but need to exclude an item in the measurement if it equals a specific value from another. Currently, my formula is: =COUNTIFS([Project Health]:[Project Health], "Red") But I need to exclude a specific Project ID in it's measurement and was thinking of doing a <> PROJ01534.โฆ
-
Calculate work days in formula, excluding weekends
I have three columns, Projected Hours to complete a task, Start Date and Finish Date. I have a Vlookup that populates the projected hours cell based on a product group identifier. Someone then enters a start date and i have a formula in the finish date cell that calculates the end date based on the projected hours. I wouldโฆ
-
SUMIFS/COUNTIFS Function: Total values but filtering out particular Status' AND Dates (Years)
Hi All, Firstly, I'll be honest and say I'm unsure whether this is a COUNTIFS or SUMIFS function but leaning towards the SUMIFS function based on my understanding of it. I'm trying to run a report to show the numner of (Column: Status) Closed Won and Closed Lost opportunities and the (Column name: Value) total value ofโฆ
-
Automatic update to count values within a specific month
Hi, I currently use aย countifs formula to count the number of met criteria within a given month. Data is entered monthly through a form. What formula can I use to automatically update the month automatically? The below formula works, but I have to manuallyย enter the first and last day of the month in its respective column.โฆ
-
How can I replace a zero value with a blank?
Hi, I would like to know how to replace a zero value with a blank? Thanks, Lynn
-
COUNT/DISTINCT/COLLECT question
I've read the Q&A on these functions but i still can't get mine to work. I'm evaluating two columns: pkg_num, and subprojectorder, then want a count of the Distinct project numbers that meet that criteria =COUNT(DISTINCT(COLLECT([project_number]1:[project_number]28), [pkg_num]1:[pkg_num]28, ="CD01",โฆ