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.
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
Autogenerating a report to send to an email recipient
From a report, I would like to auto-generate an email for a new row added. Victoria
Having trouble getting the sumif function to work. I have tried 2 versions, below =SUMIFS([Days Open]:[Days Open], Location:Location, [Repair Description]17) =SUMIF(Location:Location, [Repair Description]15, [Days Open]:[Days Open]) The [Days Open] is a number calculated by subtracting 2 dates (the cells with functions)…
Flagging Red using two conditions
Desperately trying to find a formula that does this: if due date is past and checkbox is blank then flag red in Symbol column For Row 15, tried this but it is not parseable. I used this formula in the Flag column =IF(AND([Checkbox]15 < 1,TODAY()>[Finish]15)1) says UNParseble