-
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:…
-
Weekly columns
Hi there I think I am missing something here. I want to set up a list of tasks which will be due in certain weeks of the year and are repeated. For example. * Review website pages... Second week of each month * Write a blog article: Last week of the month * Post Facebook update: Each week. Do I set up 52 columns with the…
-
Cross referencing two Sheets
Hi All I am currently using a web form to collect data for a staff onboard systems which is working great, however, I need a way to cross-reference the data coming in from the form to a list of people I am expecting. until the vlookup feature arrive later this year any ideas on how to do this would be greatly appreciated…
-
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…
-
Formulas - is there a max character/option cap, or did I mess something up?
Another formula-related question. Is there a maximum number of options (not sure of the correct term) I can use with the IF function? I'm getting an #UNPARSEABLE error. Here's the formula I'm trying to use: =IF([Bundled news section heading]126 = "Individual insurance", "Assurance individuelle", IF([Bundled news section…
-
Question: Formula results in reports
Hi! We use formulas in sheets. When will the calculation be done? Ony when having a sheet open? Or also when using the column in a report? In other words: If the formular uses TODAY or s.th. like that, the result differs from day to day. But is the result okay, when the sheet hasn´t been opened for a few days, but used in…
-
If NOT complete, change end date to TODAY()
Hi I'm trying to automatically increase the finish dates of tasks not completed, that were due for completion before today, to today. Is there any way to do that? Any help would be really useful
-
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…
-
Modified Date by Cell not row
Hi, I have a use case where I need to apply current date when a specific cell is modified--not the entire row. I understand there is cell history, but need this cell modified date visible as a value in the sheet. Thoughts? Thanks, Sean
