-
Love "PRORATE"
The PRORATE function does not exist in Excel (to my knowledge, reinventing it was cumbersome). We use it to spread budget accross time. Indeed, with the right columns and rows, Yearly (can be quarterly, monthly or whatever) budgets adjust as the dates change. Then dedicated boxes consolidate to overview at a glimpse.…
-
Print report from Project and Task Management Template
Hi, I have created a sheet utilizing the project and task management template and would like to print a report that displays only select columns of the sheet for use during a status meeting. I would like all rows to print, but only some columns. Is there a way to do this? Currently, we are hiding the columns and then…
-
Dynamic Data in a Drop Down List
I know you can up type in a list of values into a drop down list but can a drop down list be dynamically populated with data from another column? Can you use values in one column (column A) as input to a drop down for another column (column B) . By reading the data in column A and populating a form's drop down list in…
-
webform rich text editor
Are there plans to allow the webform text entry and Help text to be formatted via a Rich text or HTML editor? It would make it very helpful to highlight instructions or information for webform users. We were able to edit the style sheet in the webform Edit Mode and change the text to bold, but it didn't Save in the Preview…
-
Smart Header Rows - Feature request
Header Rows that group and/or describe the rows beneath them are very useful (especially in to-do lists) but they could be better in a couple of ways: 1. Allow users to designate rows as 'header rows' that are exempt from conditional-formatting, auto numbering and date-created fields, etc. 2. Allow a line's postion…
-
Automatically send a web form (feedback survey) as part of notification alert or conditional formatt
Is there any way to automatically send a web form (feedback survey) as part of notification alert or conditional formatting? I have a sheet with a web form that customers can use to submit requests for service. This sheet is viewable by staff that it is shared to. I also have a customer service feedback sheet that is not…
-
How can I insert multiple rows of external data without overwriting the rows below?
Oftentimes I'll copy rows from excel, email or my browser intending to insert those rows between used rows in my smartsheet. Although Smartsheet recognizes that I am pasting multiple rows, by default it will overwrite existing rows on the sheet rather than inserting new ones. This means that if I want to paste in between…
-
Changing Fiscal Year Start Dates in GANTT Settings
Is it possible to add or change the months listed under "FIscal Year Starts" in the GANTT view settings (timeline display) ? Currently, the default selections are "January, April, July, October." My organization uses an off-standard calendar quarter cycle.
-
Overriding Non-Working Days
Most of our projects include M-F working dates, however at the end of each project there is often a conference or event which may take place over a weekend or other non-working day. I'd love to be able to override and enter tasks on weekends for these instances without turning the entire project into a 7-day work week…
-
Can we create a formula using a cell that has an IF statement in it?
I have a pretty long IF statement in a cell and want to use the results from that cell in a formula for another cell. The formula I am trying to create is VERY simple; 2 cells multiplied together. But I keep getting #INVALID. The only thing I can come up with is that it's not allowed to use the information that is…
