Sign in to join the conversation:
Hi,
I have a problem with a metric widget I would like it to show me the row that is for current day. Is there a way of doing it or do I have to make a report.
You'd have to collect the information thru formulas somewhere on the sheet or another sheet. We'd then use the TODAY function to show the current day in the metrics.
Would that work?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
I created a template for a smartsheet because the previous owner no longer works for the company. I rearranged some of the columns and now the formulas are giving me this error. Can I clear the column formula and start over?
Hi Smartsheet Community! I am running into a problem and need some help with a Row ID formula using the match function. I have a project plan that is generating a unique Row ID, using a combination of an Auto ID Column Type (Row ID), the Client & Project Code, and a match formula to return the actual position of the row in…
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…