Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for October 2016
Discussion List
Need Help using the function WORKDAY
Hi there, I'm trying to use the function "WORKDAY" in order to have an end date output, based on a calculation, but when the "number_of_days" value is not a whole number, the formula returns an error. How do I have the formula always round up? Is it possible to mix the formula with the function "ROUND" with 0 digits? Thank…
FORMULAS (SUMIF?)
I have a task line 'Total Commission Percentage Earned to Rep'. As you can see, right now it says 10.03%. I need a formula that max's that percentage out at 10%. Sometimes the 10% will change to 8% ('Commission Percentage Allowed to Rep') and that will need to max out at 8% as well (the other 2% would go to 'Commission…
Suggestion for comments area
I have a settings suggestion. Mouse over comments would reveal the whole comment so i don't have to click on it to read it.. Make it a user preference. Thanx!
Clone Columns including Conditional Formatting
I have a Smartsheet that shows the status of an item by date and I'd like to be able to copy or clone the column with all the conditional formatting. Is there any way to do this?
Appending Data from Excel
Is it possible to append data to the end of a Smartsheet? I have use cases where I would like to append data to the end of a Smartsheet from and Excel file but I can't seem to figure out a way to do it? My Excel sheets have exactly the same columns that the Smartsheet has and I just want to take the data from Excel and add…
Comment title structure
Previously you could separate issues and information by a defined 'Comment Title' and then you can add comments under this section, but now the Title needs to come within the first comment and you then had replies. The problem is I am finding this change has unstructured my notes, as they cannot be clearly defined, making…
how to change the duration from days to hours
i have several sheets that i combine into one master sheet. the problem is when i link a cell that has hours in it, it translates that to days and is throwing off the calculation. how can i change the duration column so that it represents hours and not days.
Calendar view in Sights?
I have a report that I use as a "Master Calendar" for vacations, major milestones, etc. How can I put this into my Sight dashboard in "Calendar" view? When I insert the report as a widget it only allows it to come in as "Grid" view. Thanks, Armen
SUMIF YEAR
Hi, I would like to do: SUMIF(YEAR(A1:A50), 2016, B1:B50) The above doesn't work. How else can I construct this formula? thanks, Column A is a date column Column B is a currency/number column
Grouping multiple columns
Hi, I have a budget sheet that hierarchically grouped by teritotry. There are columns that captures the category and subcategory. I am able to see the total amount of each teritory individually or the whole region using the hierarchy function. If I would like to see the total for the Category or subcategory, how do I go…
