-
Make the rich text editor edit report cells on the dashboard
Greetings everyone, I was wondering if using the rich text widget to edit a cell in your report on the dashboard live is possible. The logic behind it is: The rich text editor is linked to the cell from a report and updates data simultaneously. Thus, I wouldn't need to go back and forth to the report and then to the…
-
Is it possible to get a weeks beginning/ending dates from weeknumber?
I have figured out a different set of formulas to get a beginning/ending date for a specific week and month. But have been asked if its possible to use the following: =countif(range, Weeknumber(@cell) = Weeknumber(Today()) to meet a date range criteria (something similar for month). I've tried the following with no…
-
Counting Check boxes when Checked
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. Another solution I'm thinking is possible is if…
-
Submitted Web Form - User Information
We are creating a web form to track business development possibilities. Other than adding a "Your Name" field to our web form, is there a way to see who submitted the form? On a current smartsheet where we are using a web form, I can right-click to view history, but it shows only "web form user". What we would like to see…
-
Date miss matching
Hi all, Ok so I reside and work for a company based in Bangladesh and we use this format for date ( Date / Month / Year ) so today will be 30/3/2019 I have two base sheet that feeds directly to a master sheet via direct cell linking which is used by the management to keep track of the latest updated. Now the base sheet the…
-
Working with Multiple Calendars, Vacation Days, and Weekend working days
In my project team, we have team members located in different parts of the globe. I need to link to the project non-US calendars and holidays aside from those of the US. Additionally, I need to enter the vacation days of all team members who has vacation plans or out days, and enter weekend working days when, say, a…
-
Resource Management
Creating a Resource Management plan and hitting two snags: (1) Not all sheets are being accessed for the Resource plan butResource mgmt. is turned on in all sheets (2) Not all resources are being pulled from the worksheets. Unsure what "Users in your user account" means - how do I ensure all resources are being pulled into…
-
Inconsistent format (mojibake) when exporting smartsheet Gantt to PDF
Hi, I created a Gantt with Smartsheet. Tasks names could be: - English characters only - Japanese characters only; and - a mixture of English and Japanese. When I exported the Gantt to PDF with: File => Export => Export to PDF I found that PDF generated sometimes show Mojibake (unreadable characters) when the task names…
-
Cannot format Milestones & Summary bars
I'm trying to use conditional formatting to change the color of milestones within the GANTT view. I've created a rule that looks for tasks with zero duration, and has the word Begin or Complete in it, and I'm able to locate the tasks, and format the text, but I'm not able to format the Summary Bars or Milestone indicators.…
-
Couldnt Find my Question Raised yesterday
Hello, I started a discussion yesterday but not sure where to find it now. I would like to see if anyone has posted answers to my question asked yesterday. Please Advice. Many Thanks Senthil
