-
Correctly nesting an IF formula for automated flagging in row with unchecked column, and passed date
Hi there I am new to Smartsheet. I've learned how to write basic IF() formulas successfully. Now I am trying to create a formula to turn a flag on if the checkbox column is unchecked. Also, I only want the flag to turn on, on or after a given date. The flag type column is called Arrived? And checkbox column is called PM:…
-
Report on Previous Entries
Hello! I'm curious what would be the best way to report a cells previous vs current value. For example, last month we had a status set to 15%, and this month it's updated to 20%. I'd like to see the 5% change as a percentage, or even an icon on a sight. Can this be done natively through the changelog, or would I have to…
-
Use formulas in percent complete column with dependencies enabled
I have a formula in my percent complete column, but when I enable dependencies (in my predecessor column and duration column) the formula gets wiped, leaving only the value behind. Is there a way to keep the formula when enabling dependencies or is this just a limitation of smartsheet?
-
How do I auto check a box based on a date + x # of days?
Can I get a box to auto check (so a conditional format is triggered) based on a date + 4 weeks? I want the sheet to auto tick a check box for me when something is 4 weeks past a specified date column. I want that to also correlate to another column that has a full harvey ball or % value of 100 or even just another tick…
-
Integrating Smartsheet and Mercatus
Hi, Does anyone know if you can integrate Smartsheet and Mercatus? Thanks, Y
-
Duplicate Columns in Report
Hello, I have four different promotional calendars that I am trying to merge into a summary. Each has month/week/day/date columns. When I create the report I want one set of those columns and then the promo/notes/$ etc from each individual sheet. Is this possible? It's very unsatisfactory to have four rows of dates with…
-
Jira Connector Sync - Rows getting rearranged
Everytime I update my plan on smartsheet that uses Jira connector, post the sync with Jira, it re-arranges the rows in a random order (maybe based on order of sync). Why does this happen and how can I lock the rows so that the hierarchy I define on Smartsheet manually never gets re-arranged but only receives updated value…
-
Critical Path not displaying
Hello I have read various other posts about CP not showing. My last task did have a red border but I have since altered this. There is not CP showing. Any advise will be welcome. Thanks in advance Matt
-
Sumif Problem
I get a 'incorrect augment set' error with formula =SUMIF([Int/Ext]10:[BASE VALUE $]100, "Int", [BASE VALUE $]10:[BASE VALUE $]100) and have checked that the column 'Base Value $' is a text/Number format (having looked at previous comments). Any ideas what else to check
-
Form function for SmartSheet
Hi, I have smartsheet to record each building general meeting info, such as building manager, meeting date, building name. In each meeting, we need to prepare meeting supplies (there are around 30 items, such as pen, projector, binder..). I would like to use smartsheet "Form function". Then link is created and I can send…