-
Using images in cells
I know I can insert the image into the cell. I also can copy/past images into cells. What I cannot figure out is how to combine text and images in the single cell. I have a details / notes column which I plan to use to describe details of requirements (which is a combination of a text and engineering diagrams etc.) or…
-
Formula: Not in the last (x) days
Hi, What formula gives me the same value as the above filter? Would need something like COUNT IF {Range 1} Is Not in the last (x) days Thank you!
-
Workflow Automation Separate Conditions w/ alerts
Hi, I am trying to figure out how to create one workflow where based on the dropdown value selected, it would send the appropriate alert. Example Stakeholder decision (Options - Approved, Denied, Deferred) If you select one of the three options within the dropdown, it was alert users with the appropriate email…
-
JOINING Contacts from Children rows to Parent
Hi. I have active contacts from my contact list in Children row. I would like to bring them together in one cell in parent row. I understand function COLLECT needs to be used with another function. If it is JOIN, then it lists me all the names but they are not active contacts anymore. Is there a possibility to keep them…
-
User permissions
Dear Smartsheet Community, I am turning to you because I am having an issue that I am not able to resolve. I tried to ask smartsheet directly but they haven't answered yet. I do hope you can help me. I am a licensed user (pro) and I collaborate with many other consultants (mainly free users, some pro as well). On my…
-
Formula for years and months between two dates - three dates
Hey Smartsheet! This is regarding service/employment time for employees and I want it in years and months. Right now we have one that works for just years and that formula is: =IF(DATE(YEAR(TODAY()), MONTH([Start Date]33), DAY([Start Date]33)) < TODAY(), YEAR(TODAY()) - YEAR([Start Date]33), YEAR(TODAY()) - YEAR([Start…
-
Return multiple email addresses defined by role
Hello, I want to notify people through an automated workflow. The notification should be sent to persons related to a certain role and the role-name list is stored in a separate sheet. There can be a single name or multiple names. How can I join contact values, so the joined values will give email addresses? The join…
-
Access issues in both logging in and opening certain sheets
I've been experiencing issues where Smartsheet isn't loading, giving an error: Due to network connectivity or feature updates, Smartsheet is experiencing slow loading times. When smartsheet eventually opens up, I get another error on a specific sheet: Your request has resulted in the following system messages: <blank>.…
-
Automated workflows with reference data from other sheets
I have a master worksheet with a Status column that defaults to "Submitted" for new records. Behind the master worksheet are a few sub worksheets for specific processes, along with their own status columns. In the master worksheet there are reference links for the status columns of the sub worksheets. I would like to…
-
PMO template questions
I’m relatively new to Smartsheet, and I’m trying to use the PMO template as the basis of my design, but I have a couple of questions: 1) I see other posts on this Community talking about the step-by-step instructions for the PMO template, but I can’t locate those instructions. Can someone point me in the right direction?…
