-
Customized notification
Hi, Community member: I have already set up the notification and successfully. However, I want to add one more feature. Currently, my smartsheet has several columns: building, building name, building manager, reports delivery method (e.g., mail/email/courier) , mailing info (who should receive) and email info(who should…
-
CountIF formula for two different columns??
I'm looking to find a way to create a count statement if one column contains "a" and the other column contains "b". Example: If "Status" is "Open" and "Issue Type" is "Bug",then count # I looked to the formula example sheet for this but all I see in one that I believe would work has a "expand rows to see example" message…
-
Keystroke(s) to quickly enter toady's date?
Hello, In Excel it's {ctrl}; Is there a way to do it in a date field on a SmartSheet?
-
Possible to Search Sharing Lists?
We have several sheets with 30-50 collaborators. Unfortunately, the people setting up these sheets haven't used groups, so when we need to determine if a sheet has been shared to a specific person, the only way to find out is to scroll through the list. Is there a way to search the list of Shared users (like there is for…
-
Admin in a Report Workspace?
Hello - I have an unlicensed user that would like to be able to edit the report properties for a report that I created for him. I know you need admin rights to the whole workspace, but I can't do that because he's only allowed to have edit on the master sheet. If I create a new workspace only for his reports where I give…
-
Time sheets on site
Anybody got a timesheet template. I have a construction company running about 5 sites. I would like to send out a weekly timesheet "form" to employees which will have the following options to fill in. Monday, Tuesday, Wednesday, Thursday, Friday, Saturday * Choice of location of sites * No of hours. * Total Hours week…
-
Sights monthly calender
Can you put a monthly calendar in sights? Seems to only go in a gantt format
-
See Projects and Tasks on Resource Views
Task List assignees are not reflected on the resource view. I mean i created a task list and assigned a person to each task, but it does not appear on the resource view, and it seems like it only shows assigned tasks inside a project sheet. can someone validate this for me please, as I need to see the allocation of each…
-
Edit Column Properties
Hi, I have a spreadsheet to record building name, building manager and support staff assigned. Each row represent one building. After I import excel to smartsheet, I try to change the column properties of building manager from text/number to contact list. However, on the screen, it requires me to enter name or email…
-
Email address contacts - not working
Hi Team, Recently, Smartsheet is not allowing me to add contacts. It comes up with 'Please enter a valid email address'. I have never had this problem till today. Is there a current bug? Thanks, Mark