Best Of
Re: Formula to have a check box ticked when a date is reached
Hi Mitch,
Try something like this.
This formula will tick the box if the date is today or earlier. Because the formula contains the TODAY function, the sheet will need to på activated for the formula to update.
Make sense?
=IF([email protected] <= TODAY(); 1)
The same version but with the below changes for your and others convenience.
=IF([email protected] <= TODAY(), 1)
Depending on your country, you’ll need to exchange the comma to a period and the semi-colon to a comma.
Would that work?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!
Sheet Quick Edit
Hello,
This may already exist but...
In my smartsheet, I have linkages to other sheets where information gets entered (call this sheet 1) and then summarized on my sheet (sheet 2). It would be convenient to edit sheet 1 from sheet 2 in some sort of pop-up window so I never have to leave my main sheet.
Something like this but where the "Program Info" sheet could be edited right from this window, making my sheet 1 very easy to manage.
Re: Task bar option not showing in Conditional Formatting
Hi @Isabelle L
The "Task Bar" option is only available when the 'apply to' in the Conditional Formatting instructions is set to the entire row:
See: Set where you want the format applied in the Conditional Formatting article.
Cheers,
Genevieve
Re: Task bar option not showing in Conditional Formatting
Hi @Isabelle L
I hope you're well and safe!
It only works/shows if you select the Entire Row.
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Re: How do I set an automation to trigger 3 days before a date in a column?
You can delete the condition.
Did that work?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Dynamic Group - From Cell
Update a Contact Group from a Cell in a sheet to ensure that the correct people are always in the group with out needing to go to the Account Administrator to update the Group,
Re: Count entries by month/Yr/ total time
Excellent!
You're more than welcome!
To convert it to hours, you'd add /60 at the end.
=SUMIFS({Task Time}, {WO Start}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY())) / 60
Did that work?
Re: Populating Entire Columns Referencing Another Sheet
Hi @Muhammad
My apologies for the delay, I missed this notification! I understand that you need to reference data, and that a Report cannot be referenced.
The second sheet would need to have one column that will help match the data across sheets. It looks like you have this set up with a Date column called "Week Of", which should work for your purposes! Once you have the week you're looking for, you can use WEEKNUMBER to identify if the dates in your source sheets match the weeknumber in your current row.
For example, in your AVG formula, you could use it like this:
=AVG(COLLECT({Column to Avg}, {Date Column}, WEEKNUMBER(@cell) = WEEKNUMBER([Week Of]@row)))
Let me know if I've still misunderstood what you're looking to do! if so, it would be helpful to see all the current formulas you're using, and identify which one needs to be updated.
Cheers,
Genevieve
Allow Reports to display Attachments as a thumbnail
We use Forms to capture defective works in the field which then attaches an image to each row in our Defective Works Sheet.
We would like to be able to have a column assigned as an Attachment field in order to have the Report display text fields with the accompanying image in the body of the report, rather than the little paperclip icon.
This would allow us to issue the Report as a PDF with the embedded image in each row.
Re: Provide users with the ability to Print a Grouped Report
+1
We need to schedule production in the factory and are using Smartsheet to distribute the information. The grouped report shows the schedule by production line, however the printed version looses this advantage and becomes difficult to read. As well as using the online version, we need to print off the sheet and it is disappointing that the printed version is useless for our purposes at the moment. The workaround we are doing at the moment is to transfer the data into an excel sheet and manually recreate the schedule by production line.
Yuliya D
