Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Import Excel file and include embedded imagesIn Using SmartsheetHi, I was not able to find a way to import an Excel file that has images embedded in cells, and keep those images when the import in complete. Is that possible? Am I missing something? Or do I have to re-import those images manually,…
-
automated update requests for multiple rowsIn Using SmartsheetI am looking for how to send multiple rows in the same automated update request. We need to confirm contact information for building proctors. 1 person might be the proctor for 10 buildings. I do not want to send this person 10 separate…
-
System "Modified Date"In Formulas and FunctionsI have a column in my sheet that is the system Modified (Date) date and time. I need to know the latest date and time in that column because sometimes the date is the same but the time is different. MAX only works with the date part. Ca…Answered - Pending Review 35 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Calendar App - Users unable to create new eventsIn Premium Apps and IntegrationsHi there, I created a shared calendar for my team using the Calendar App and for some reason, my team is unable to create new events. I've tried the following - Ensured "allow new event" is checked in the advanced settings of the…
-
Multiplying column values?In Formulas and FunctionsHi Community, I have a sheet with section score values ("Ease Score", "Permanence Score", "Impact Score", "Cost Score") that I am trying to multiply to find an overall score ("Project Score&qu…
-
Linking Children to ParentsIn Using SmartsheetI need to use SmartSheet as a data collection tool. The user will have a sheet with Company information including a unique Company ID. I need a way for them to enter Contacts tied to the Companies by the Company ID I thought about using F…
-
Hide Rows from Viewers or ReportIn Formulas and FunctionsHi I have a project that I have created. I want to share the plan with a client but our template has the financials of the project in it. Obviously I do not want them to see this. Is there a way that I can hide certain rows from a viewer…
-
Project Health Formula to Auto Populate a SymbolIn Formulas and FunctionsHi I have a formula that flags the health of each row (task) via a RAG status. Green is healthy, Amber is at risk or in progress and Red is a failure. This is set up to work off the start date and % complete. However, it just isn't right. …Answered - Pending Review 18 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Help with Formula - Look a value in a cell and if it is 1 of 4 values fill in a different cellIn Formulas and FunctionsI'm importing data from a legacy excel sheet and the priority is designated with a 1-4 with a critical to low. I want to check that column and if it is one of the values it puts an update severity in a different column. Since the new sever…
-
New Format Reversal DateIn Using SmartsheetThis is not something you can generic response your way out of. Do not tell me to "submit an enhancement request" while you sweep this colossal failure under the rug. Answer the question. Will Smartsheet allow users to adjust the…