-
SCC: Dynamic Report Scope - Shows grouping headers but no rows of data?
One of my Dynamic Report Scopes built in SCC is not showing any data. It displays the grouping headers, and if i change filters the grouping headers change as if the data has changed. But the actual rows of data are not being displayed. There is also a warning at top saying: Not finding the rows you're looking for? Try…
-
Why isn't the workflow triggering and moving the data to another sheet?
Hi, I have the following workflow set up where the data needs to move to the delivered sheet once the date is in the past. For some reason, the workflow is not working. Both sheets have the exact same column headings. Can someone review and let me know what's missing?
-
Disabling sheets, reports and/or dashboards without deleting them
As a company, we are trying to determine what grids, reports, dashboards, etc. that people are using. Is there a way to disable items without deleting them? That way if it is decided that we still need something, we don't have to recreate it.
-
Complex nested IF, AND with traffic light symbols
Hi All, I'm working on automating a symbol highlighter to indicate project progress as well as alerting if key milestones are being compromised. The formula below is structured based on the following columns: * Finish: The Activity completion date * Start: The activity start date * Date: A column containing fixed dates to…
-
Formula for RYGB Status
Hi, I'm currently using this formula for status health but it's not the best because "Not Started" status is not showing Red if the End Date for the task is in the past. Obviously, the task is overdue even if it hasn't started. Can anyone assist to make this formula better? =IF(Status@row = "Complete", "Blue",…
-
ad sheet to report automatically
i have a folder under "sheets" that has all my ongoing project. i made a few reports that sum up info from all sheets my problem is that every time i add a sheet to the folder i need to manually add it to all my reports how can i make it that every sheet i add to that folder will automatically be added to a report?
-
Interacting with reports error
Hi all, Running into an issue. So I have 5 depts that will be updating their progress in a lifecycle management of the product I'm tracking. I have created a sheet where I get all the overview and have conditional formatting whenever someone clicks on the checkbox their portion becomes green. The issue I'm running into is…
-
Sorting ascending order (monthly)
Hi, I'm having trouble organizing the column in ascending order. I'm trying to plot this into the dashboard and after Jan comes Oct as I'm trying to group them together. Before I tried not to put a number before the month that messed up the order more. Not sure how to fix it. Any input will be appreciated.
-
Report grouping by system generated date?
I'd like to create a report that groups entries by created date, without the timestamp. The entries come from a form, and adding a system generated 'created date' is more efficient. However the grouping function ends up splitting every entry separately because of the timestamps being different. Is there a way to group by…
-
Change a cell value If a certain Postal/Zip Code is entered, is it possible?
Hi there helpful people! I am using smartsheet to track jobs in order to then export a monthly report. I have approx 2000 postal/zip codes attributed to client sites within a particular State - and what I'm hoping to do is set up an automation (either within a workflow or a formula) where if a particular postal/zip code is…