-
% Complete column automation populating '100 (text) instead of 100% after recent update
Hi everyone, I'm hoping someone has run into this and found a fix. After a recent Smartsheet update, my automation that sets the % Complete column to 100% when a task is marked complete is now populating '100 instead of 100% β storing it as text rather than a number. This is breaking my downstream schedule logic thatβ¦
-
Using a checkbox in formula
Hello All, My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below: =IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK") I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date orderedβ¦
-
Update Assigned Person only for active phases
Hi, Iβm using Smartsheet with a Master Sheet(All over Projects Basic Summary) and Individual project sheets that have multiple phases. When I change the Assigned Person in the Master Sheet, I want: β’It to update only phases that are Not Started or In Progress β’It should not change phases that are Completed Is thisβ¦
-
Counting number of items from a specific month with multiple criteria
I'm trying to count the number of items that were published for each LOB in our operation during each month. I've tried a dozen different formulas, but I can't seem to get any to work. I currently have a sheet summary with the following: =COUNTIFS([Received Month]:[Received Month], IFERROR(MONTH(@cell ), 0) = 1, (LOB,β¦
-
Filter On by Default? - Publish to Dashboard
Is there a way you can "lock" a specific filter on by default for a sheet you publish to a dashboard? I'd like to have the sheet editable from the dashboard, but I'd like it filtered to "current user" so it can act like a one-stop shop for everyone to review the reports and update the sheet at once. I have one filter onβ¦
-
Total Sum not calculating in Smartsheet correctly
Hello SmartSheet Community. I have created a report with various categories and totals. I wanted to capture certain categories and their totals however the totals are not calculating correctly. I would have to copy the totals, paste them to an excel blank sheet and AutoSum there. Can someone see what I am doing wrong?
-
Expiration Date Automation
I have a column called expiration date and another called proposal status. When the date is in the past in the expiration date column , I want the cell in the proposal status column to change to "expired" How do I set this up?
-
How to Connect Data from Project Metrics to Portfolio Summary
Could someone provide guidance on how to link data from the project metrics back to the Portfolio Summary after a project has been provisioned? I am trying to connect timeline finish dates & status dates back to the Portfolio Summary. Thanks!
-
How to create a unique number via formula or how to autonumber via formula due to existing autonumber type column?
All, The way my Smartsheet workspace works: Every time the Status column of a particular request in Master sheet is changed, the entire row is automated to be copied to Status Tracking sheet. The change is timestamped as Change Timestamp and the Subsequent Timestamp is recorded in Status Tracking sheet with everyβ¦
-
Average days in a status & oldest status date
Hello - I have a client data sheet, and one of the columns is New Account Status. I've added a column called Misc. 1 that tracks when the New Account Status is changed to Ready to Open. I have a separate Metrics sheet to track a variety of metrics on. Making any changes to the main client sheet (changing column names,β¦