-
ADD LAST COMPLETE DATE
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Completion Date will register the date of last column that changed to "complete" status. I really appreciate any help! Rob
-
How can I stop my Sheet Summary from changing the location of a cell when form data comes in?
I am creating an inventory form that populates data into a sheet on "Top of Sheet". I want to create a summary sheet that reflects how much of an item we need vs what we have entered on the count (via the form). My issue is, whenever a form gets filled out, it also shifts the cell I am trying to reference down. I want it…
-
PDF reports with totals
Is there any way to show the totals on a report when sent in PDF form? Anyone found a solution or workaround?
-
Copy & paste shortcut vs. keyboard
Has anyone else experienced this, and is there a reason why this happens? When I am trying to copy and paste, it works fine when I use ctrl+c and ctrl+v, but if I try to copy using the right click option, it appears nothing happens because there isn't an option to paste after, & if I try ctrl+v, it doesn't paste anything.…
-
Conditional Formatting Not Updating in Reports?
I'm finding that conditional formatting is not consistently updating in reports, and my staff are complaining about it. See for example below, the "Rollinson Downstairs..." task highlighted has no conditional formatting even though the date has passed. If I open the Rollinson sheet, it then updates and updates the report.…
-
Free Webinar: Forms Best Practices
Join us January 13th for our webinar "Forms Best Practices." In this webinar, you’ll learn best practices for creating, customizing, and sharing Smartsheet forms to collect and capture data. We will be hosting 3 sessions across multiple timezones, if you are not able to join us live, feel free to still register and we will…
-
Count Netdays if Project Status is "Complete"
Hello Forum, I am having difficulty writing a formula to count NETDAYS if a project status is "Complete". I hope this is not too confusing, but here goes..... 3 COLUMNS: "Project Status", "Actual Start Date", and "Actual End Date" I have a grid with 200+ projects/rows (Project Intake Sheet), and would like the formula to…
-
Record changes to only 1 cell
In a sheet where another user and I download files and mark them in different stages (proofed, processed, uploaded), is there a way to record who last modified a cell rather than a whole row? I'd like to have a cell automatically record who changed which phase. I know that I'm able to right-click a cell to see its history,…
-
Formula that will allow a date in text format to be captured in a date format
I have a Date getting imported as 08JUN2021 (2charDay+3charMonth+4charYear) and I need to switch it to a Date format that will allow integration in other formulas and logic flows. So far I have tried these 2 formulas without success: =DATE(VALUE(RIGHT([WES Evaluable Report Date]@row, 4)), VALUE(VLOOKUP(MID([WES Evaluable…
-
Update date column when another column drop-down is selected
Looking for the formula to change a column to a date when another column drop-down is selected. The date would reflect the actual date the column drop-down list was selected Example If EPMO Stakeholder Decision (Approved, Declined, Deferred) is selected The EPMO approval date will auto-update to the date when the EPMO…
