- Adding updates to cells
Hello everyone I need some assistance in updating individual cells. Listed below are columns, each one pertaining to external software tools we check daily. The rows are network elements. If a tool is ready, my team would mark the cell, corresponding to that network element with a Y to indicate it's ready. N is not ready…
- How to use any date within a date range as formula criteria?
O, great wizards of the Smartsheet community, hoping you can help me cast a formula spell. Trying to create a formula to flag if a resource is overallocated in a master sheet that tracks resources across multiple projects. NOT using either the legacy resource management or RM by SS, just core Sheet functionality. I managed…
- What is the sheet limit for a free trial user?
I'm using the free trial and I'm getting a notification that I need to upgrade my plan to create more sheets. Does anyone know what the sheet limit is for the free trial, and where that information is shown? Thanks!
- Add Contact details on bulk upload
I am trying to add contact details on the bulk upload but it allows me to add just name and email. I want to add Name, title, email, company name, office phone number, mobile phone number etc. how can i do that?
- PMT calc
Is there a similar function to PMT? =PMT(rate, period, pv, fv) etc? Have not been able to find one. Thank you.
- Daily Update Solution without the need to open the sheet, use Zapier, or similar
Hi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open it or similar. 1. Add a so-called helper column. (Date). We can call it Today Helper and add a date before the current day.…
- What reports are tied to a sheet?
Hi - is there a way to see which reports a particular sheet is feeding?
- Expand/Collapse all option in sheets
I would appreciate a similar option to expand/collapse all in pivo tables in excel. I would anticipate that this would work for all items that are parents of the same hierarchical level. ie in this image I could right click on the "enable leader" header and click "collapse all" and all sub-project information would be…
- Moving singular cell data into a sheet from a master sheet with autonomy?
I am sure this has been asked before, but I have scoured many forums and attempted many solutions but to no avail. My issue: I have a sheet (let's call it master) that holds metadata. I also have another sheet (let's call it Department) that relies on a single piece of metadata from Master, but also requires the ability to…
- Recording Week Tasks Were Completed
嗨!与一个老问题了,我回来了me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…
