-
Links in webforms that link to OTHER webforms
Hi there, One of my clients has many events that occur at their main event. I have created a webform for the various stakeholders to request catering, AV, etc. I had challenges in distilling the data down to a usable function. There were 85 columns because I had to much information in one place. I created other sheets that…
-
Netdays - if blank
Hello all -- I have created a column to show me how many days between "today" and the expected close date of a sale. This is the formula I'm using: =NETDAYS(TODAY(), Close Date16) This is working, but I have one problem: I don't always have an expected close date. In those situations, I want the cell to display as blank.…
-
Time Between Dates, dependant on status of another column
Hi, Hopefully I can get this to make sense. We have a spreadsheet that has a Date Reported Column and classification column (classifications being - near miss, incident, injury) with a formula column. Is there a way to create a formula in the formula column that has the number of days between today and the latest date in…
-
Email Addresses with .net
Hi Team, When adding email addresses to contact list, I am receiving 'Please enter a valid email address' for any that end with .net.au Does Smartsheet not support this extension? Thanks, Mark
-
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…
-
Sights monthly calender
Can you put a monthly calendar in sights? Seems to only go in a gantt format
-
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…
-
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…
-
Counting a value that appears within a row
I am building an inventory sheet for a nonprofit board and identified a number of criteria the board governance committee will need to track. I've created various demographic columns such as age, ethnicity, residence, etc. The formula below has worked for all the columns created so far but getting "unparseable" error. I've…
-
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
