-
Dashboard can't be publish
When I want to publish my dashboard, it always show me an error message. The situation continue few days. How can I resolve it ? thanks.
-
Problem with Multi-sheet Report interpreting identical columns as unique
I am having difficulty with not understanding how to force SmartSheet row reports to understand that a particular column I have on multiple sheets is indeed the same thing, and I want it displayed on the report as a single column. It somehow does this automatically and sometimes correctly identifies this, other times not.…
-
How can I keep the colors in the calendar app view from changing when data is changed?
I built a calendar view from a report (no pre-selected colors assigned), which has primary and secondary grouping. The colors assigned were fine, however whenever the in-line data was changed through the detail view that pops up when you click on a calendar bar, all the colors for the entire view would change to other…
-
Return just one row in my report
I wanted to create an ability in my Workapp or Dashboard that would pass the filter criteria to a Report and show only the filtered rows. Is that possible? Is there a workaround?
-
Enhancement Request - Has anyone witnessed an actual enhancement???
I suppose I'm venting here. I've been on this forum for a long time, and I'm so frustrated. I think there are a lot of excellent ideas here that could greatly improve Smartsheet (I could misspell the name, but I won't). The "Enhancement Request" link must be the second most frequently used term here. close second to…
-
Conditional Formatting multiple cells when equal to value of another cell?
Hello! I need help with conditional formatting in my sheet. I have 8 columns that are fixed to Employee Names (for shift schedules). I want the functionality for someone to go in and select their name from a dropdown and then have their shift times (when their name is in a cell) to be highlighted. I have another column…
-
IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
-
Time Being Added to a Date and Day Concatenation
Hi, I am setting up a scheduling report for my Team and would like to group each task in the report by a column that is a concatenation of the task start date with the day of the week for that date (e.g., 12/20/24 - Friday). When I create this concatenation using the formula below it works, but also adds a time of day into…
-
View Multi-Day Tasks in a Report Grouped by Day
I have built a scheduling tool in Smartsheet for my Team to track standard, ad hoc, training, and PTO. I have setup a report that pulls scheduling data from multiple sheets with tasks grouped by start date. I use this report to see how my Team is scheduled during a given week. Unfortunately, in this report, tasks that…
-
More than 2 actions following an approval
Is it possible to have more than 2 actions after an approval in the same workflow? We have a sheet that requires the tasks to be approved by a member of leadership. If it is approved I need the project lead to get an alert, the date to be recorded, and the status to be changed. I would prefer not to have multiple…
