-
Does Smartsheet provide a means of calculating project costs over time?
Hi all, I'm currently setting up a number of project plans on Smartsheet and need to also implement a budget plan for these, particularly to baseline how costs are projected to be spent over time. What I am looking for is an in-built means of calculating the sum of resource rates and material costs over time, throughout…
-
Timestamp - Record Date & Time in a Field
Hi there, I want to set up a workflow with multiple approval steps and record e.g. when each step was approved; is there a way to push the 'current' date and time - as a fixed value, not as =TODAY() - into a cell ? The modified date/time only catches the last modification of the whole line, so that's not going to work for…
-
Error when creating login
I have been sharing our project plans to customers with their permissions as a viewer. I have a customer who is receiving the attached error when clicking the link to create a login. I did delete her as a user and resend the user invite, but she got the same error.
-
My Smartsheet link didn't refresh
Hi... My client sent a Smartsheet link to edit. It was shared to 6 of us (staffs). My question is why is it my Smartsheet only has 36 rows and the rest of my colleagues are having the updated 948 rows...I already clicked on refresh report button but still I only got 36 rows in my Smartsheet. What seems to be the problem?…
-
Counting cells with multiple selections and criteria
HI- I'm trying to count the cells for the developer (1st criteria) and priority (2nd criteria) which sometimes has multiple selections. It is only pulling counts for those cells that have one option selected. I need for it to pull counts for the developer even when there are more than one priority selected in 2nd criteria…
-
Smartsheet access
Can i provide access to some projects in smartsheets for folks outside of my organization(vendor)? If yes , any warning should i be aware of?
-
When no actual cost is entered, want variance to show 0
I am very new to smart sheets. Trying to figure out a formula that would show my variance as 0 or blank if there is no actual cost entered instead of showing a negative number (the budgeted cost number). To spare any confusion I won't even begin to type the formulas I have written.
-
URGENT Need for help
Hello all, I understand this might not be the real place to ask my question, but am stuck and in need of help. My scubscription ends in a few days, and I am having trouble chenging my credit card details on smartsheet site. I have already submitted 2 support tickets, and written once to finance@smartsheet.com without any…
-
IF and AND
IF(AND(Status1 = "Complete", Status2 = "Complete", Status3 = "Complete"), "All Tasks Complete", "Tasks Incomplete") I would like to know if it is possible to pull out the information from the column instead of a "text" i.e: =IF(AND({5S Audit Score Entry Range 5}=[Cell Name]@row1,{5S Audit Score Entry Range 6}="4", {5S…
-
Kanban style dashboard
Hello, I would like to build a kanban style dashboard from a project plan or any other sheet that contains an action/owner/status. The second step, is I can create this Dashboard to bring together actions from multiple sheets. e.g. I can have action list 01 and action list 02. Bringing them together could show me the…