-
Function best for Evaluations
This snapshot is from our company's evaluations of our employees. Now we are looking to populate the "MARKS" Column. The equation should read in the Attendance@row:Efficiency@row cell range, if it finds "Excellent" it populates a Green Status Bubble, if it finds "Good" it populates a Gray Status Bubble, if it finds "Fair"…
-
How do I change the formula in the Metadata sheet so that I can include data from two columns?
Hi Smartsheet Community I am trying to edit a donut chart that displays projects by Change Impact (High-Medium-Low) across all stages (Initiate, Plan, Implement, Close, Closed) - while excluding Closed projects. Currently my data is taken from the metadata sheet - which unfortunately doesn't include the distinction by…
-
Summary field = date selected from project plan
So I have a standard project plan with timeline / gantt chart. Start date = [Start] and end date = [Finish] I have several mini projects in my smartsheet so have used the level calculation to detect level = 0 for start of my mini projects with levels 1 onwards for the children tasks I have successfully written the formual…
-
Conditional Linking
Hi Guys, Have delved a bit into linking sheets and writing functions etc. in the past but I am starting to get out of my depth - Is there a way to intersperse the two, so something like: If X then LINK So IF Sheet1, column X is ticked, then LINK the contents of those rows in Sheet 1 to Sheet 2 =IF(sheet1columA), "1", LINK…
-
How can I apply this formula to the entire column?
I can't seem to apply this formula to the entire column. it tells me that the column syntax formula isn't quite right. =IF([Closed Date]1 = "", TODAY() - [Entry Date]1, [Closed Date]1 - [Entry Date]1)
-
#BOOLEAN Expected Duplicate Month checkbox formula assistance
Formula I am using =COUNTIFS({F & A Monthly Updates Range 2}, Department@row, {F & A Monthly Updates Range 3}, "3"). The problem I am facing is when submissions are made multiple times for a duplicative month. For example, the form has a system column to capture the date the submission on the sheet form was made. If I…
-
Count "Red" symbols in Sheet Summary
Hi all, New to Smartsheet and wondering how I get my sheet summary to count the number of "Red" symbols for status reporting. Understand that COUNTIF won't count symbols from what I have read. Does anyone have a way around this? Thanks in advance.
-
How can I make my calendar reflect the color of a data selection?
Hi! I am making a calendar that will include multiple locations that will then be put on our company webpage so all global employees can see what is going on at any other location. People from different offices will be able to fill out the form and it will auto update on the webpage. I have a dropdown with the different…
-
Trying to use SUMIF to add columns a crossed a row
Below is the formula I am using =SUMIF([Committed Or Projected]@row:[Committed Or Projected]@row, "Projected", [Jan-23]@row:[Dec-23]@row) The error message I am getting is #incorrect Argument set. I am basically trying to add a row range if a value is set in another column. Can Sumif only be used on columns,s not Rows?
-
Formula for [date]+1 month?
Hi all, If I was using excel, I'd use: '=DATE(YEAR($A1),MONTH($A1)+1,DAY($A1)) However the equivalent smartsheet formula... '=DATE(YEAR([Column2]12), MONTH([Column2]12) + 1, DAY([Column2]12)) ...doesn't seem to be very "smart" at all, because it gets to December and can't handle the concept of rolling over into the next…
