-
Creating a Time sheet form which shows existing projects as drop down
I am evaluating Smartsheet and one of my use cases is for my team to be able to enter time spent against projects which have been approved. I am trying to find a way of being able to include in the form a reference to my project master sheet but can't seem to find a way to achieve this. Has anyone been able to solve this…
-
Automation - Alert When a Certain Number of Rows have been Added
We're using a form/sheet to collect registrations. Is there any way to set up an alert when a certain number of registrations (rows) have been submitted?
-
Update Request does not allow editing field
I have a workflow that sends an update request to each resource assigned. I'm trying to get them to update "% Complete", but it's showing as uneditable. The user is an Editor, and it does allow them to edit other fields, such as Task Name and Resource Name. The % Complete is not a locked column, and the row(s) are also not…
-
Why is the mobile app showing me a different form?
Hello everyone, I hope you are having a good Sunday afternoon, I created a form that works very well on computer. On the other hand, when I open the same form on the smartsheet application for a mobile phone, it seems that it does not take into account certain logic that I have programmed. Before opening a ticket with the…
-
Certification Badge Transferred
I took and passed the product certification exam on December 2, 2020 under my previous employer Booz Allen Hamilton account. I no longer work for the firm, however, would like to get my badge transferred to this profile? Please advise. Thank you, Cynkita Rasberry
-
zero value when import from excel
We are importing data from excel into Smartsheet. In excel, we hide the zero values, but when we import the data in smartsheet, the "0" shows up. We import invoice data, sometimes these are 3 lines only, sometimes these are 10 lines. In Excel we hide any "0" value when we the linked cell is empty (so we have formula's/…
-
How to create a move-in/move-out inspection workflow?
Hi All, In property management, it's common for a tenant to do a move-in Inspection and for the landlord to do a move-out inspection. The two inspections are then compared to determine if the tenant owes money for damages. I am trying to figure out how to use SmartSheet for this workflow. The steps are: Tenant completes…
-
Link between files, also include deleted or added rows
Dear, I made a new file "budget" which is linked to my project portfolio sheet. I noticed that when I added a new row to the project portfolio sheet, this new row is not added to my file "budget". The cells in file "budget" are linked with "link from cell in other sheet". Is this the correct way to appoach this matter? How…
-
Automation - reminder emails
Hi I am trying to set up an automation that every Monday at 9am (the trigger) two colleagues get an email notification with set lines from our SS that have reached a set condition. However no email is coming through. I have tried so many different things and have to keep retrying with pretend triggers in an hours time to…
-
Error Circular Reference
I'm trying to pull information into a row depending of the information in another column from the same sheet but in the same row. So I made this formula, when It is in one cell I don't have problems but when I paste the formula in other cells o make a column formula I have the message "#CIRCULAR REFERENCE".…
