-
IF command and Date
Hi, I have 2 columns: Next Audit Due Date and Status If the date in ‘Next Audit Due Date’ column is greater than the current date, I would like the ‘Status’ column to fill in green and return value of On Track. If the date in ‘Next Audit Due Date’ column is less than the current date, I would like the ‘Status’ column to…
-
Hyperlink in a value cell with formulas
Hi, I have a hyperlink question and wonder if someone can help me out.... I have a cell with values auto calculated by a formula to show the number of task done. In this cell, I would like to add a hyperlink to a report so when I click the number I can see details in the report. However, it seems formula and hyperlink…
-
Conditional formatting based on time from today
I want to create conditional formatting rules on a Date column and cannot figure out how to enter Today in the criteria Example: Select column = EOL Date is < TODAY = Red is between TODAY() and TODAY() + 180 = Yellow is > TODAY() + 181 = Green I can do it in Excel just fine but when i enter TODAY() in the criteria it says…
-
Copy Cross-sheet formulas from one sheets to another
I want to insert a couple of cross sheets formulas in the monthly data file that I add to smartsheet. It was easy to do but now I need to go back and add new columns and the formulas to past data files (several hundred). This is tedious but can be done over time. Is there any way to create a cross sheet formula in one…
-
Problem Saving Blueprint
Hello Smartsheet, Reposing again in hopes that you can assist me. I've added a new sheet to my Blueprint (I've done this before). The sheet has one profile field (Project Name). I don't need anything on the sheet to report out to anywhere. When I try to save my Blueprint, I receive an error "add more column(s) to reporting…
-
Solicit Comments, but prevent user from viewing other's comments
Hello All, We use comments pretty extensively to communicate updates and share "next step" info internally. I would like to request updates, and include comments to external collaborators, but prevent them from seeing what has been previously posted. Is there a way to do this? Thanks, Alex
-
Transfer of Sheets owned by an individual no longer with the company
Hi, In User Management, I would like to transfer Ownership of sheets, from an individual who left the company to another user. Will this transfer, need to be approved by the Sheet owner (who is no longer with the company?) How does this work? Thank you, Deepthi
-
Commercial real estate best practices
Hi Community, We are looking to connect with some fellow commercial real estate management (or similar) companies to share use cases and best practices. Anyone out there? Thanks in advance!
-
#Divide by zero error
I am having trouble with this error and need help with the formula 4 Columns (let's call them A,B, C, F) Formula used is: =SUM(Column B + Column C)/ Column A How do I make Column F equal Zero (0) when Column A is equal to Zero (0) Thanks, BM
-
Acceso a Informes con Acceso Incorrecto
Hola, he creado un único informe para que accedan a diferentes usuarios. Estará configurado el informe para que muestre las líneas en la que, la cuenta de usuario coincida con la cuenta de usuario que crea la línea o cuando coincida la cuenta de usuario con una columna con fórmula cuenta. Este informe funciona…
