Hi all! I'm trying to setup a formula that allows me to count actions (in red) and that also shows me the weekday in which they were made. The columns I'm using for this are 'S' and 'Action Creation D…
Hi all! I'm currently trying to count how many red entries (in the "Puri Safety" column) are in the month of June (using the "Created" column). I'm trying to use the following formula: =COUNTIFS(Creat…
=DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) - WEEKDAY(TODAY())) It is the Weekday part of the formula that is stopping it from running. Using INT and VALUE and whatever else I can think of doesn…
Hi all, I'm having trouble embedding a powerpoint file in my Dashboard. Whenever I add the link, I get an error message (photo attached). Currently, I go into my powerpoint file, click File, and then …
Hi, is there a possibility to display 2 logos at the sheet level? I know that I can include a logo image to the workspace and that will replace the "smartsheet" logo from all files within that workspa…
I thought I was in a Report. BUT I was in a filter and I deleted several columns from a sheet. I do not have a backup. In the recent history it will not show the data in the columns either. HELP!
Hi, I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones…
I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to…
Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month (May), I want the counter to return "5". I've been trying to use the formula …