-
Displaying the most recent Comment
Good Morning, I have a dashboard that displays information for a morning meeting, it is all numbers, percentages and charts. I have had no problem with it up until now, I have been asked to add a comment function. Where the meeting head can click, then type a comment to display onto the dashboard before he prints it and…
-
MEDIAN on another sheet, sometimes throwing #INCORRECT ARGUMENT SET
I have a summary sheet, pointing to another sheet where I'm gather median hours based on a specific criteria in a column formula. I have a Coordinator Column as the reference point. The other sheet should use the Coordinator and get the median of my Days column based on other criteria. =IFERROR(IF(OR([Total NEW Tasks]@row…
-
COUNTIF/AND/NOT Formula
Good afternoon; So, I'm trying to create a Summary field for a sheet that counts the number of active projects therein. Some projects are completed (we're not archiving these yet), or on hold, or cancelled or whatever, so I don't want those in the total. My thought was to COUNTIF everything in the [Current Status] column,…
-
Check Boxes and Cross-Sheet References
Hello Smartsheets Community! I have possibly a complicated question. I have two sheets, one is essentially a "job log" while the other is an "order sheet" with items for several different jobs. Is it possible to have one box on the job log be checked once all of the items for that job on the order sheet have been checked?…
-
Resource Management - Formula for various different schedules
Hi all, CC:@Genevieve P. I'm using smartsheet for resource management and the sheet links to our smartsheet resource tool. In RM smartsheet, we have different resources on different schedules e.g: Some work 7 hours a day Some work part time (4 hours a day) Some work 4 days a week at 8 hours and 7 hours (Fridays off) We…
-
Formula Help Within Sheet
Alright, SmartSheet community. You've always been good to me with helping out. I've got a real "stumper" here. Let's say I have six columns on my sheet (in reality there's many, many more; but these are the ones relevant to my question): Start Date (a Date/Time column type) End Date (a Date/Time column type) Allocation %…
-
How to reference Summary Sheet field in Report Filter
I have a Sheet Summary Field that I want to use as part of the filter criteria in a report. How to I reference it in the filter? Alternatively, how can I use the Sheet Summary field in formula on a different sheet (than the Sheet Summary Field is created on) to mimic the report filter.
-
How to do an IF, AND and Multiply scenario with multiple options
I am trying to do an IF, AND and Multiply scenario with multiple options. I still need to add the 3rd option, but wanted to figure out what I am doing wrong. I tested the first option, it worked. Adding the 2nd resulted in Unparsable.
-
IF AND NOT
Need help with some formulas Important Columns : Schedule Health, Status, Target Start Date, Target End Date Schedule Health will hold the formula - changing to RED GREEN and YELLOW Depending on formula Green : IF Today is < than Target Start Date, AND/OR Status = "Complete" Yellow = IF Today is >= Target Start Date, AND…
-
What formula to use for days remaining before due/start date?
Hello community, I am currently a little stuck trying to figure out what formula to use for the "days remaining before conference" column. I'd like to have a number there to know how many days are left before the 'start date' of the conference. Do I need to add a hidden TODAY column or automation? I'm still fairly new to…
