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.
Discussion List
How Do I create a value based on a date or date range?
I have a due date column that I am trying to return a specific value from.My fiscal year runs from 10/1/17 through 9/30/18. Is there a formula that I can write that would pull the fiscal year and month and put that in a cell based on said due date? So if a due date is say 12/14/17, I would like it to say Dec FY18 in that…
Issues assigning tasks to non-licensed users
We are at the beginning of our Smartsheet implementation and are having issues with assigning tasks to project team members that do not have Smartsheet licenses. The error we receive is: The user never receives the email referenced in the error message so they are unable to proceed. Have any of you run into this issue? If…
Integration with KIVUE
Hi Do you currently integrate with KIVUE or have any plans to do so? https://www.kivue.co.uk/ We use this for our month end project reporting and it would be great if I could take detail from Smartsheet into this tool. Thanks. A
Smartsheet needs to have differentiation between a "text" column type and a number
When integrating data in other apps and programs, the data type is critical. Additionally, We need to be able to lock out the data type in the entry. I should not be allowed to type text into a date field or text into a number field. etc. This will enhance the reporting and BI usefulness of this tool.
Sort Rows A - Z messing up formulars
Hi Team, I use the top row in my sheet to calculate data in the sheet, because I cant freeze the top row when I do a "Sort Rows A - Z" it moves the formula even though I use ([$Row$1]:[$Row$50]....... I was looking at Cell linking the rows with the date I need in another sheet so the top row in the new sheet would never…
Colouring Cells using a formula.
Good Day All: I would like a cell to change color (background color) based on a range(See Below). Has anyone used such a formula? My Sheet: https://app.smartsheet.com/b/publish?EQBCT=906e1a0d8f8342e4baead18e6d0a76e4 Overall Rating Score 4.6 - 5.0 (Green) 3.6 - 4.5 (Light Green) 2.6 - 3.5 (Yellow) 2.0 - 2.5 (Light Red) <2…
Automatic Count Down
Does anyone know a formula that will automatically count down? I am currently using =DATE1-TODAY() The problem with this is that I have to open the sheet everyday to update the count down date. Thanks, Steph
Notification and Report of open tasks for all smartsheets
Is there a way to create a weekly notification that has enclosed within it a report for each user's outstanding tasks from all of our active smartsheets? In other words, I have 30 projects and in those 30 projects, Lisa and Dave have tasks. I want to remind Lisa and Dave each week of all the tasks that they have in those…
How to collect comments from individual sheets, cell-link to a master sheet (eventually Sights)
Hello everyone, For my dashboard (Sights), I show status updates from individual projects. There are multiple updates columns per project I have to pick up. For now, I added extra rows on top of project, and people fill in updates there. Then I cell-link those columns to a master sheet (and create a report for dashboard).…
Sending multiple rows in vertical format
In a report, is there a way to send to an email recipient two rows at the same time in vertical format? Victoria
