-
Best practises for alerting contacts not shared to one sheet
Hi all , AS a project manager , I want to share information to stakeholders which are not necessarily predefined in my contact list or not set as preferred contact in the contact list column . I have set the restrictions level to "unrestricted" so that I can add any contact to the distribution list for a certain type of…
-
Alert not sent to email
Hi, I have set up a very basic alert workflow which doesn't seem to send an email to one specific recipient. The workflows is: when a row is added, notify 3 people (two are @company, one is @gmail.com). However, only two of them receive a message. The alert isn't sent to one of the two @company recipients. The automation…
-
Date vs. System Date Column
If a sheet has a system generated date column and multiple date columns, do those date columns mess with the generated columns? Because I created workflows to move rows to another sheet when a status in the status column is reached. However, if there is a date in one of the date columns it changes the System date column…
-
[% Complete] interaction with [Actual Finish Date]
Hi all, We would like [Actual Finish Date] be set to the date that [% Compete] is set to 100% I thought this would be straight forward: [Actual Finish Date] =IF([% Complete] = 1, [Last Entry Date], "") <[Last Entry Date] is a “Auto-Number/System” column type with the value Modified(Date).> Problem is [Last Entry Date] is…
-
Automated Message Activity & Ownership
I have several questions: Is there an activity log that shows the automated messages that are actually sent from Smartsheet? I transferred ownership of a sheet to fully licensed user, but my name (as former owner) still appears on all the notifications. How do we change this?
-
I want only certain parent rows and their children in my report. How can I accomplish this?
I have an Action Item Registry grid sheet with multiple projects. Each project is a parent with several children categories. I am creating a report at the project level and want to pull information from the Action Item Registry, but only for the specific project. How can I filter a parent row and all of its children, while…
-
How do i highlight a cell to be red/green based on the 2 date columns I have?
I have about 10 columns of different Plan and Actual due dates . I am trying to get the the Actual Column date to highlight in green when it is before or equivalent to the Planned date. How do I do this? in the conditional formatting i'm limited based on the calendar, when it's actually based on the input for the planned…
-
Project Resource View - Hours
Hi, I am managing a project right now, and I want to see to how many hours per resource each time I assigned a tasks. The project that I am managing will run in 1 year so I want to capture and see like how many hours they spent to date. In my sheet, I have an 'actual hours' column and 'assigned to' column (This is multiple…
-
New user access in dynamic view
hi , In my current project, some of end users are not added in non licences smartsheet account(organization account) but i will share dynamic view access to the users using view settings.. when i share dynamic view, users 1st sign up and then login smartsheet account.. so my question is to access dynamic view, users must…
-
Count Function not working
Hello, I am using a COUNTIF function as shown in the screenshot attached, and it is grabbing the "Complete - Handover to VAR" Status field, but not the "ONB - No Reply by VAR" status field. There is some conditional formatting applied, but I'm not sure what the formulae isn't calculating the ONB - No Reply by VAR field.…