-
Removing Multiple Link
I have created and tested a few examples of the master sheet where it links data from two base sheets. The bases sheets are maintained by my team and I don't require any changes. I have successfully done so but due to me testing a few times, the bases sheets are showing, each cell, data is outbound linked to <unknown…
-
Enhancement Request
Ability to require text input into a column for approval requests. This would allow the approver to explain the reason for approval or decline. Right now I have an update request based on the approval column, but this requires 2 separate emails. I can use a dropdown with an update request and lock the columns, but that…
-
Issue setting up report for name off Contact List that has no hits yet
Is there no way to create a report pulling off someone in a column's contact list without actually having an instance of that contact being mentioned in the source sheet? For example, sheet ABC has an "Assigned To" contact list column that includes "Bob". However, Bob does not actually have any tasks assigned to him yet. I…
-
Using a checkbox to countif
I am trying to count based on 2 criteria if checkbox is checked. So far it only returns a zero value when the checkbox is checked. Here is what I have... =COUNTIFS({Real-Steel Estimator Review Total Loss Tes Range 1}, "true", {Real-Steel Estimator Review Total Loss Tes Range 2}, Appraiser5, {Real-Steel Estimator Review…
-
Slack Connection went down
Hi, We have both email and Slack notifications set up to notify project managers when creative requests come in. Last Thursday I renamed the Slack channel, and the PMs stopped receiving notifications through Slack. I received an error message stating the rule was invalid, so I updated to connect with the new Slack channel…
-
Conditional Formatting Question?
Hello! I'm very new to smartsheets and have been using them for probably 6 months and I have to create a sheet with conditional formatting where the date drives the coloring of the entire row. I've watched the video's and searched Q&A, however; I feel like my questions are specific to the work I'm doing. Is there any other…
-
Close current sheet
I really am not a fan of everything being on the left, but in "trying" to get use to the new layout I have yet to find a way to close the current sheet. I don't want to click on a new sheet just for the current sheet to fall to recent (too many already sit in there now), but I want it to close. Is there a way to close…
-
Today's Date in a Dashboard
Hi, I have recently gotten into using Dashboards within Smartsheet, amazing. Is there a way to display today's date in a widget? Thank, Scott
-
Formula for Duplicates
I am looking for a formula that does not count the duplicates so that it can count unchecked boxes. Does anyone know of one?
-
Conditional Formatting to change status?
Hi, I'd like to be able to change the row status (planning/in progress/complete/overdue) depending on a required date in another column in that same row. I have a report set up to report all overdue tasks and I'ld like to automate it more to change the status of all overdue tasks without any input from me. Is this…