-
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…
-
Button to add text to pictures is missing in Android app
Hi, According to the following help article there should be a button to add text to pictures when uploading pictures with the Android app. This button is missing in the app on my phone and on my tablet. I updated both devices to Version 9.3.0 Build 323. Is it possible to solve this? Screenshot from the article: Screenshot…
-
Can you block users from adding new lines after a certain number?
We are using a sheet to track candidates for a position. We need X number of candidates to Y positions. We're using a formatting trick to show when the target number has been exceeded but it would be nice to be able to limit the number. Users would still need to edit the existing candidates.
-
Copying rows to the top of a sheet (Automation)
Hi Everyone, This question was asked before but I have not found an answer. So asking again to see if there is any new development which I have missed. I have set up an automation to copy rows from each project sheet to a master sheet (based on some trigger). The row for the first project was copied arbitrarily in the…
-
Consistent [Column Name] Formula
Hi, Is there a way to add like a string "[Column Name]" so whenever I add a new column that has that name the formula stays refrenced to that new column with the same name? Thank you!