-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Add "active" email addresses into Dashboard
I have a list of project team members on the Dashboard. Is there a way to show email address that will create an email when "clicked on"?
-
Copy-paste an image into a field in a webform
Hi, I have a form for users to report bugs in software (and I'm sure I'm not alone in that!). Users should be able to copy-paste a screenshot directly into a regular field in the form, instead of having to save the image and then upload it. You can do this in the sheet itself (works a charm), but you can't do it in a form…
-
IF Formula Question
Hi there, I am kind of new to SS formulas and I am trying to create a function that adds an amount to a column IF that column is a certain deal type. The columns that I need the addition to are labeled "Development WAG $" and "Implementation Costs $". IF the "Deal Type" column has "Lease/ Purchase" I need the $350,000 to…
-
How to make a "Tasks by Status" Widget on Dashboard
Anyone have a clue how to make this Tasks by Status Widget on a Dashboard? Is this made using a report or is it just a widget? My goal is to list how many Tasks are on a report that are green, yellow, and red in the same exact format shown. Thank you!
-
Resource Allocation – Multiple Task owners in one Task
Hi, How can I allocate the resources in single task when I have multiple task owners or multiple Task managers? * How can i allocate the hours based on individual manager? Best Regards Saqib
-
RTF in Dashboard Widget
I downloaded an example dashboard which tracked multiple projects. Looked good and decided to build my dashboard to match example. Example dashboard has a Rich Text Widget which has multiple formats within. However when I try to use the rich text widget it does not allow me to have varied formats (different text sizes,…
-
Desk reservation form
Hello, How do I create a form that will allow a user to reserve a desk for a particular day and remove that desk from a list of available desks? Within the same form, I will also need to allow for recurring dates? For example: If an employee comes to the office every Tuesday and Thursday, they could reserve that desk for…
-
Emergency Preparedness with Smartsheet
Hello SS Community! Does anyone of examples of a Corporate Emergency Preparedness Checklist that one can share with me as a starting point? Tips greatly appreciated!! Thank you!
-
Calculate the time between two dates by days, hours and minutes
Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basically, i need to calculate the time between two columns (date received) and (date documents issued) in days, hours and minutes. Cell 'O2'…